SQL数据操作(给B表插入数据时候在数据必须存在于A表)
CREATE TRIGGER [dbo].[trg_Test_B_Num]
ON [dbo].[Test_B]
FOR INSERT
AS
SET NOCOUNT ON
IF NOT EXISTS(SELECT [num] FROM [dbo].[Test_A],[INSERTED] WHERE [Test_A].num=[INSERTED].A_num)
BEG
原创
2015-09-28 14:09:30 ·
493 阅读 ·
0 评论