User Id :    Password :      New Member   Forgot Password  
 
How to check case sensitivity in sql-server
Description Here we describe the way to check case sensitivity in sql-server   No. of Views     1770
  Rating     5
Author Sumit Gupta   Posted On     13 Apr 2011
Tags SQL SERVER,SQL SERVER : How To    

Sample Code   Download Code

SELECT * FROM YourTableName  
WHERE YourColumnName COLLATE Latin1_General_CS_AS = ‘your parameter or data’

 

About Author

About Author I am Sumit Gupta working in 3 Pillar Global Pvt. Ltd as Module Lead. I have 7+ year of experience in .Net technologies. I love to explore new technologies and write technical article. Sumit Gupta
No Photo
 
Country India
Company 3 Pillar Global Pvt. Ltd.
Home Page http://www.facebook.com/sumitgupta1225

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

   
Write your comment here.
Comment
Verification Code