Question

我想写的是触发点。当表1中出现条目时,表2应插入同样的数值。在表1的某些领域,必须更新表2。我如何知道是否添加或更新价值?

我被插入,以添加价值。

请指导我。

Answer 1

这里,你将知道在这样的触发点中是否添加或更新价值:

on INSERT, the inserted dynamic table is populated with the new values
on UPDATE, the inserted dynamic table is populated with the new values of the records that were updated, and the deleted dynamic table is poulated with the old values of the records that were updated

因此,如果<代码>删除表格中包含(假设你有背栏)的复制件(见<>编码>。表格可以保证,该编码为UPD,造成触发。如果<代码>删除表格是空的,反之,是<代码>。 INSERT。

Answer 2

use this trigger to solve your problem.. create TRIGGER [dbo].[insert_Assets_Tran]
ON [dbo].[AssetMaster]
AFTER INSERT , UPDATE
AS BEGIN
DECLARE @isnum TINYINT;

SlectT @isnum = COUNT(*)

IF (@isnum = 1)
INSERT INTO AssetTransaction
select [AssetId],[Brandname],[SrNo],[Modelno],[Processor],[Ram],[Hdd],[Display],[Os],[Office],[Purchasedt] ,[Expirydt],[Vendor],[VendorAMC],[Typename],[LocationName],[Empid],[CreatedBy],[CreatedOn],[ModifiedBy] ,[ModifiedOn],[Remark],[AssetStatus],[Category],[Oylstartdt],[Oylenddt],[Configuration] ,[AStatus],[Tassign]

FROM inserted;
ELSE
RAISERROR( some fields not supplied , 16, 1)
WITH SETERROR;
END

友情链接