存储过程的传入参数是怎么回事啊？

[tinaws12]

create procedure proc1
as
declare @userid int,
@username varchar(20),
select userid ,username,useraddress from user
where userid =@userid and username = @username

这样写不对吗？

[sdhdy]

create procedure proc1
@userid int,
@username varchar(20)
as
select userid ,username,useraddress from user
where userid =@userid and username = @username
--执行存储过程
exec proc1 1,'asdf'

[aierong]

create procedure proc1
as
declare @userid int,
@username varchar(20),
select userid ,username,useraddress from user
where userid =@userid and username = @username


语法上是没有错误的

但是存储过程没有发挥作用

[伍子V5]

传入参数不是这个意思
create procedure proc1
@userid int,@username varchar(20)
as
exec 'select userid ,username,useraddress from user
where userid ='+@userid+' and username = '''+@username+''''
go

[aierong]

create procedure proc1 @userid int,@username varchar(20)
as
select userid ,username,useraddress from user
where userid =@userid and username = @username
--run
exec proc1 具体数值,具体数值

这样你就可以进行有效查询啦

[FoxLinn]

利用SQL的向导吧，它会帮你写好的，你再分析，就明白了

[cyg1dm]

楼上你你瞎蒙什么呀？

[pengdali]

create procedure proc1
@userid int,
@username varchar(20)
as
select userid ,username,useraddress from user
where userid =@userid and username = @username
go

--调用
exec 34,'sdfasdf'