检查记录存在或已更改或新建 [英] Check record exist or changed or new

问题描述

我想要比较两个表格，如

[被许可人]，[ENGINENO]，[HULLNO]，[ENGINETYPE]，[所有者]，[YARD]，[规范]，[ORDATE ]，[DLDATE]



一张桌子有修改过的记录



我想要显示两张桌子的记录被修改为gridview

I want to compare two tables having columns like
[Licensee],[ENGINENO],[HULLNO],[ENGINETYPE],[OWNER],[YARD],[Spec],[ORDATE],[DLDATE]

one table had modified records

I want to show both tables's record which are modified into gridview

推荐答案

IF NOT EXISTS( SELECT * FROM TABLENAME WHERE ID = @NewId)
BEGIN
    --INSERT THE RECORD
END
ELSE
BEGIN
    --UPDATE THE RECORD
END

你可以使用以下方法来支付这个



1.

Hi,

You can use below methods for this

1.

IF NOT EXISTS( SELECT * FROM TABLENAME WHERE ID = @NewId)
BEGIN
    --INSERT THE RECORD
END
ELSE
BEGIN
    --UPDATE THE RECORD
END

2.

2.

MERGE INTO Target as t
USING Source as s
    ON t.ID = s.ID
WHEN MATCHED THEN
    UPDATE SET t.Name = s.Name, t.Address = s.Address
WHEN NOT MATCHED BY TARGET THEN
    INSERT (Id, Name, Address)
    VALUES (s.Id, s.Name, s.Address)
WHEN NOT MATCHED BY SOURCE THEN
    DELETE OUTPUT

action，inserted.id，deleted.id

action, inserted.id, deleted.id

这篇关于检查记录存在或已更改或新建的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！