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

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,284 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 2013/06/18 | Source: SQLServerCentral.com | Category: capitalize
Rating: |  Discuss |   Briefcase | 191 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,068 reads
   Items 1 to 3 of 3