Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag CASE Rss

Search for any content tagged case

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 3 of 3   
 

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,477 reads

Case Cleanup Function

Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).  Read more...
By Sean Smith 2008/08/14 | Source: SQLServerCentral.com | Category: capitalize
Rating: |  Discuss |   Briefcase | 254 reads

Random DEFAULT string for a column using CASE and NEWID

Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random
Rating: |  Discuss |   Briefcase | 1,084 reads
   Items 1 to 3 of 3