alter trigger trgStu on stu for delete as declare @sqlCmd nvarchar(1000), @tableName varchar(128), @id varchar, @pkColumnName varchar(128) begin select @id=2 --id from deleted set @tableName='---' set @pkColumnName = 'id' set @sqlCmd='delete from '+ @tableName+' where '+ @pkColumnName+'=' + @id print @sqlCmd exec sp_executesql @sqlCmd end
no title
最新推荐文章于 2023-10-09 19:13:20 发布