摘要: Create TRIGGER [dbo].[trigInstructionsDelete]ON dbo.Instructions instead OF DELETEAS BEGIN DECLARE @InsId INT SELECT @InsId=InstructionsID FROM deleted --删除 DELETE dbo.Transfer WHERE InstructionsID=@InsId DELETE dbo.Instructions WHERE InstructionsID=@InsIdEND 阅读全文
posted @ 2013-08-16 10:47 xw2cc 阅读(182) 评论(0) 推荐(0) 编辑