2013年8月16日
SQL觸發器聯級刪除
摘要： 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 阅读(191) 评论(0) 推荐(0)