April 7, 2011

Make password case sensitive in SQL Server

SELECT * FROM dbo.UserInfo
Where
Type = 'Admin'
AND
Password COLLATE Latin1_General_CS_AS = 'adMiN1239'

No comments:

Post a Comment