COALESCE (Transact-SQL)

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

DNN module skin container settings are stored in the TabModules table. Use the following SQL statement to reset all containers: update TabModules s...

[Read the rest of this article...]

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

Syntax: SELECT field1 [ , field2 [ , ... ] ] INTO newtable FROM source field1 Is a parameter that specifies the list of the fields that are to b...

[Read the rest of this article...]

Here's a great sql script to use for the DotNetNuke Reports Module: Select --   AU.Username,    U.FirstName,   ...

[Read the rest of this article...]