使用该MERGE
语句。
http://technet.microsoft.com/zh- CN/library/bb510625.aspx
让我看看是否可以放一些东西。
编辑:示例
MERGE INTO [TargetTable] AS T
USING (SELECT l.T AS 'id' FROM @list l ) AS S
ON (T.[id] = S.[id])
WHEN MATCHED THEN
UPDATE SET
T.updated = 1
WHEN NOT MATCHED THEN
INSERT VALUES ([insert value into each column of target table]);
编辑2:参数@list
是您使用ID填充所传递的列表