Sign in
intellectually constipated
patrick gallucci's sql server brain drain
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
.net
Business Intelligence
Common Table Expressions
Data Warehouse
Derived Tables
Erwin
Gadgets
general
IC Dictionary
Indexed Views
Katmai
Microsoft Certified Architect
Pages
Query Processing
SQL Function
SQL Script
sql server 2005
SQL Server 2008
SQL Server Stored Procedure
SQLCMD
ssis
Training
vista
visual studio
Windows Mobile
Archive
Archives
April 2008
(1)
February 2008
(2)
November 2007
(1)
October 2007
(2)
September 2007
(5)
August 2007
(7)
July 2007
(4)
December 2006
(3)
May 2006
(7)
October 2005
(3)
September 2005
(2)
December 2004
(1)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
intellectually constipated
SQLCMD and the power of the little r
Posted
over 6 years ago
by
MSDNArchive
3
Comments
I would have to say that one of my favorite new utilities that shipped with SQL Server 2005 has been the SQLCMD utility . I am going to demonstrate the use of include files. The following is the complete call syntax for SQLCMD. sqlcmd [{ { -U login_id...
intellectually constipated
SQL Server Function to get the Hour of the Month
Posted
over 6 years ago
by
MSDNArchive
1
Comments
This function returns an integer of the hour of the month passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfMonth]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP...
intellectually constipated
SQL Server Function to return half year number of days.
Posted
over 6 years ago
by
MSDNArchive
1
Comments
This function returns an integer of the number of days in the half year. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHalfYearDays]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP...
intellectually constipated
SQL Server Function to get the Hour of the Year
Posted
over 6 years ago
by
MSDNArchive
1
Comments
This function returns an integer of the hour of the year passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfYear]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP...
intellectually constipated
HALO 3
Posted
over 6 years ago
by
MSDNArchive
2
Comments
Nothing else to be said. GOOCH
Page 1 of 1 (5 items)