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

Content with tag CASE Rss

   Items 1 to 11 of 11   
 

Unravel Some Complex IF Logic

By Dwain Camps 2014/01/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,091 reads

CASE vagaries

By NT 2013/09/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,518 reads

Assigning categories to values 2

By Hugo Kornelis 2013/05/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,272 reads

Assigning categories to values 1

By Hugo Kornelis 2013/05/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,362 reads

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,485 reads

T-SQL: CASE Statement

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...  Read more...
By Jen McCown 2012/12/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,957 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

Demystifying the use of CASE in an ORDER BY statement

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.  Read more...
By Chuck Hoffman 2012/04/26 | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 14,949 reads

SQL Server CASE Law

SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.   Read more...
By Additional Articles 2011/03/14 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,589 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 | 260 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 11 of 11   
 
Tags
t-sql (8)    
blogs (1)    
capitalize (1)    
character (1)    
cleanup (1)    
convert (1)    
date manipulation (1)    
datetime (1)    
default (1)    
first (1)    
newid() (1)    
order (1)    
rand() (1)    
random (1)    
standardize (1)    
upper (1)