关于binary
sp:
ALTER PROCEDURE sp_Accounts_UpdatePassword
@UserID int,
@Password binary(20)
AS
UPDATE Accounts_Users
SET Password=@Password
WHERE UserID = @UserID
执行sp:
exec sp_Accounts_UpdatePassword (1,cast ('2' as binary(20)))
提示:
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: '1' 附近有语法错误。