CREATE PROCEDURE dt_1_checkpassword
@username char(25)
@passwd char(25)
AS
declare @shopper int
if exists (select idShopper from shopper where chrUserName=@username )
begin
if exists ( select idShopper from shopper where chrUserName=@username and chrPassword=@passwd )
select idShopper , chrUserName, UserName=case when len(chrShopperName)<5 then
chrUserName
else
chrShopperName
end
from shopper where chrUserName=@username and chrPassword=@passwd
else
select idShopper= -1
end
else
select idShopper= -2
报@passwd附近有语法错误及必须声明变量"@username"错误
请问要怎么改呀

@username char(25)
后面有一个＂，＂吗？

CREATE PROCEDURE dt_1_checkpassword
(
@username char(25),
@passwd char(25)
)
AS

括号可以不要，但“,”必须要有

谢谢，我想请教一下这两个变量
@username char(25)
@passwd char(25)
as
declare @shopper int

所在的位置有什么区别呐。

as 之前的是程序里传过来的参数，AS之后的是自己定义的变量。