Login  Register 
Home
 
Applications
 
Consulting
 
Design
 
Business Links
 
Support
 
Contact
  Search
Search
 
 SupportKnowledge BaseMicrosoft SQL ServerSQL Scripts     May 17, 2012  
Snippets

SQL Scripts

 

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

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,   U.LastName,   AM....

[Read the rest of this article...]

 

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

 
 Copyright 2012 by Global Internet Business Solutions   Terms Of Use  Privacy Statement