数据库中的存储过程的问题

[jt474922748]

alter proc userinfoproc
@name varchar(20),
@pwd varchar(20),
@tablename varchar(20),
@tableIDname varchar(20),
@tableselewhere varchar(2000),
@tableID int,
@type int
as
begin
if(@type=0)
begin
insert into userinfo values(@name,@pwd);
end
else if(@type=1)
begin
select * from userinfo;
end
else if(@type=2)
begin
select * from userinfo where @tableIDname=@tableID;
end
else if(@type=3)
begin
delete from userinfo where @tableselewhere;
end
end

exec userinfoproc 'admin','admin','uid','uid',6,2

select * from userinfo

[jt474922748]

alter proc userinfoproc
@name varchar(20),
@pwd varchar(20),
@tableIDname varchar(20),
@tableID int,
@type int
as
begin
if(@type=0)
begin
insert into userinfo values(@name,@pwd);
end
else if(@type=1)
begin
select * from userinfo;
end
else if(@type=2)
begin
select * from userinfo where @tableIDname=@tableID;
end
else if(@type=3)
begin
delete from userinfo where @tableIDname=@tableID
end
end

exec userinfoproc 'admin','admin','uid',6,2
对不起
发错了

[lzp4881]

alter proc userinfoproc
@name varchar(20),
@pwd varchar(20),
@tableIDname varchar(20),
@tableID int,
@type int
as

declare @strSQL varchar(2000)

begin
if(@type=0)
begin
Set @strSQL='insert into userinfo values('+cast(@name as varchar)+','+cast(@pwd as varchar)+')'
end
else if(@type=1)
begin
Set @strSQL='select * from userinfo'
end
else if(@type=2)
begin
Set @strSQL='select * from userinfo where '+@tableIDname+'='+cast(@tableID as varchar)
end
else if(@type=3)
begin
Set @strSQL='delete from userinfo where '+@tableIDname+'='+cast(@tableID as varchar)
end
end

exec (@strSQL)
GO

[anbs01]

问什么？

[lzp4881]

exec userinfoproc 'admin','admin','uid','uid',6,2
少一个参数，需要7个参数，你这只有6个