Replace Null or Empty Value with String

SQL Timeout on Custom DNN module Try running . . . . exec sp_updatestats;
Alter Table - Setting a Column Default Value ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName
Formatting a Short Date in SQL using Convert Function 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 ...