以前在sql server 2000中写的存储过程,导入到2012后,没用反回值。存储过程如下:CREATE PROCEDURE GUser @Account varchar(30),
@Pwd varchar(30)
ASSet nocount onSELECT * FROM WinUser
WHERE (Account = @Account) AND (Pwd = @Pwd) AND (RepealSign = 1)GO请问原因。谢谢
@Pwd varchar(30)
ASSet nocount onSELECT * FROM WinUser
WHERE (Account = @Account) AND (Pwd = @Pwd) AND (RepealSign = 1)GO请问原因。谢谢
SELECT * FROM WinUser
WHERE (Account = @Account) AND (Pwd = @Pwd) AND (RepealSign = 1)
把参数替换了
这句话去掉看看!