DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
 
 
SITE SEARCH SQLUSA.com VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES
How to handle Case Sensitive columns in Case Insensitive database?

Typically a database is set to Case Insensitive collation. This approach has many advantages, because case sensitivity adds another layer of complexity to the database application. However, sometimes the applications require Case Sensitive columns. If it is a third party application, it may require that the entire database be set Case Sensitive. In-house applications, however, can be satisfied by setting specific columns as Case Sensitive.

Execute the following script in Query Editor to set a column to an Case Sensitive collation. Rebuild the table after the change:

ALTER TABLE SalesDiscount ALTER COLUMN DiscountType varchar(40)
COLLATE SQL_Latin1_General_CP1_CS_AI null

Alternate approach - use a case sensitive collation in ORDER BY:

SELECT ProductName=Name, ListPrice

FROM AdventureWorks2008.Production.Product

WHERE ListPrice > 0

ORDER BY Name COLLATE SQL_Latin1_General_CP850_CS_AS

 

/*

ProductName             ListPrice

All-Purpose Bike Stand  159.00

AWC Logo Cap            8.99

Bike Wash - Dissolver   7.95

Cable Lock              25.00

Chain                   20.24

.....

*/

Exam Prep 70-461
SQL 2016 DESIGN & PROGRAMMING
 
 
 
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE