CREATE PROCEDURE delid
@id int,
@tablename nvarchar(20)
AS
DECLARE @table1 nvarchar( 20 )
set @table1 = @tablename
exec('delete from '+@table1+' where id='+@id)
GO
@id int,
@tablename nvarchar(20)
AS
DECLARE @table1 nvarchar( 20 )
set @table1 = @tablename
exec('delete from '+@table1+' where id='+@id)
GO
CREATE PROCEDURE delid
@id int,
@tablename nvarchar(20)
AS
DECLARE @sql nvarchar(1000)
set @sql= 'delete from ' + @tablename + ' where id = ' + @id
execute(@sql)
GO
@id int,
@tablename nvarchar(20)
AS
DECLARE @table1 nvarchar(20)
set @table1 = @tablename
exec ('delete from '+@table1+' where id=@id')
GO