SQL Scripts

Snippets


SQL Scripts

 

NO Image:
21
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...]

12
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
Posted in: SQL Scripts
27
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...]

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

[Read the rest of this article...]

Page 3 of 3First   Previous   1  2  [3]  Next   Last