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)
BEGIN
PRINT 'THE A_num NOT EXISTS [dbo].[Test_A]'
ROLLBACK TRANSACTION --回滚﹐避免加入
END
GO