Try running . . . . exec sp_updatestats; SQL, DNN

Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL

ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName SQL, Alter Table

To work around this problem, follow these steps on the computer that Windows Server 2003 or Windows XP SP2 is installed on: Make sure that the ...

[Read the rest of this article...]

SQL, Network DTC Access

To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to&nb...

[Read the rest of this article...]

SQL, Date, Convert

Add the helper SPLIT function to your database CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) )  RETURNS @RtnVal...

[Read the rest of this article...]

SQL, FUNCTION