SQL Scripts

Formatting a Short Date in SQL using Convert Function

DNN Expert posted on August 12, 2011 11:26

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...

Posted in: SQL Scripts

Actions: E-mail | Permalink | Comments (0)

DNN Expert posted on April 27, 2011 06:01

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

Posted in: SQL Scripts

Actions: E-mail | Permalink | Comments (0)

DNN Expert posted on April 10, 2011 13:27

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

Actions: E-mail | Permalink | Comments (0)

P.O. BOX 2342 ~ BREWSTER, MA 02631
PHONE & FAX: (508) 714-0678