日期:2014-05-18 浏览次数:20461 次
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'