Home > SQL

Query to verify case sensitive columns in SQL SERVER having Case insensitive Collation

2. March 2013

How to to verify case sensitive columns in SQL SERVER having Case insensitive Collation.

Use this query

SELECT * FROM LoginData WHERE username ='something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';
OR

SELECT * FROM LoginData WHERE username LIKE 'something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';

 

SQL ,

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading