如何在SQL Server08中检查区分大小写的密码
问题描述：
在我的应用程序中，我正在向数据库发送密码，请说我的密码是PassworD123.现在这给了我适当的值，但是当我使用password123..it时也给了我适当的值.因此，如何在SQL Server中处理区分大小写的数据.任何演示代码都会有所帮助.谢谢.
In my application I am sending password to database,lets say my Password is PassworD123. Now this is giving me proper value ,but when i am using password123..its also giving me the proper value.So how to chaeck for case sensitive data in SQL server. Any demo code will help. Thanks.
答
您可以在T-SQL语句中使用COLLATE子句.
You can use COLLATE clause in your T-SQL statement.
例如.
SELECT * FROM dbo.TableName WHERE Password = @ password COLLATE SQL_Latin1_General_CP1_CS_AS