用触发器限制一次删除的行数
CREATE TRIGGER TRI_NAME_DEL ON [dbo].[Table] FOR DELETE AS if @@rowcount>1 begin print '请不要一次删除多于一条的记录!' rollback transaction end
CREATE TRIGGER TRI_NAME_DEL ON [dbo].[Table] FOR DELETE AS if @@rowcount>1 begin print '请不要一次删除多于一条的记录!' rollback transaction end