SQL Server，如何从用户定义的表类型中删除更新元素？

使用该

MERGE

http://technet.microsoft.com/zh-
CN/library/bb510625.aspx

让我看看是否可以放一些东西。

编辑：示例

MERGE INTO [TargetTable] AS TUSING (SELECt l.T AS 'id' FROM @list l ) AS SON (T.[id] = S.[id])WHEN MATCHED THEN    UPDATE SET        T.updated = 1WHEN NOT MATCHED THEN    INSERT VALUES ([insert value into each column of target table]);

编辑2：参数

@list