In this article I am going to explain how to Check Case-Sensitivity in SQL Server.
In previous article I have explained how to create comma separated list in Sqlserver, how to encrypt store procedure, view and function in sql server and howto take database Backup and restore using command T-Sql.
SQL server determines case sensitivity by collation. COLLATE is the T-SQL clause used to specify a particular collation for an expression. We can use this to validate the users enter password at the time of login.