use MyQQ
go
create proc LoginUser
@id int,
@pwd varchar 
as
select Id,LoginPwd from users where id=@id and LoginPwd=@pwd

use MyQQ
go

--varchar参数加长度
create proc LoginUser
@id int,
@pwd varchar(2000)
as
select Id,LoginPwd from users where id=@id and LoginPwd=@pwd

--调用
exec LoginUser 10000,'0000'

------解决方案--------------------
use MyQQ
go
create proc LoginUser
@id int,
@pwd varchar varchar(100)
as
select Id,LoginPwd from users where id=@id and LoginPwd=@pwd

exec LoginUser @id=10000,@pwd='0000'