Case sensitive search in SQL Server queries

Password Case Sensitive Search

Use COLLATE clause in your T-SQL statement.

SELECT * FROM dbo.TableName WHERE username=@username 

and Password = @ password COLLATE SQL_Latin1_General_CP1_CS_AS