存储过程变量问题??

Question

不好意思，Must declare the variable '@table2'.中'@table2' 应该是'@table'

Answer 1

CREATE PROC sp_del
@id int,
@table varchar(50),
@col varchar(20)
AS
Exec('delete from '+@table+' where '+@col+'=@id)GO

Answer 2

CREATE PROC sp_del
@id int,
@table varchar(50),
@col varchar(20)
AS
exec("delete from "+@table+" where @col=@id")GO

Answer 3

CREATE PROC sp_del
@id int,
@table varchar(50),
@col varchar(20)
AS
exec('delete from '+@table+' where '+@col+'='+@id+'')

Answer 4

CREATE PROC sp_del
@id int,
@table varchar(50),
@col varchar(20)
AS
Exec('delete from '+@table+' where "'+@col+'"='@id)GO