SQL Parametrik Tablo Adı İle Insert işlemi (SQL parametric table name insert)


create proc Test(@tableName varchar(100),@data varchar(200))
as
begin
declare @sql varchar(250)
select @sql = 'insert into ' + quotename(@tableName) + '(ColumnName) values(''' + @data + ''')'
exec (@sql)
end

Yorumlar