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 HEADLINES NEWS
SQL E/BOOKS   SQL 2014 PROGRAMMING   DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
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
Exam 70-461
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