34,590
社区成员
发帖
与我相关
我的任务
分享
create trigger del_tableName on TableName
for delete
as
declare @i int
set @i=(select ID from deleted)
delete from tabneName where CHARINDEX(LTRIM(ID),'2,3,4,5,6')>0
delete from tabneName where id in('2','3','4','5','6')
---你写错了吧!