SQL Server, How to removed updates elements from User-Defined Table Type?
I have a User-Defined Table Type, lets say `@TT dbo.IntType readonly,`
IntType is batch of `int`, as Primary-Key

    CREATE TYPE [dbo].[IntType] AS TABLE(
    	[T] [int] NOT NULL,
    	PRIMARY KEY CLUSTERED 

I like to do `UPDATE` based on all key(`int`) in `IntType`, and `INSERT` new rows for the key(`int`) not exist in the database (an upsert)

I wonder if theres a easy way to remove the "UPDATED" key(`int`)? Then I can insert the rest.
*(or if you have a super one-line upsert for SQL Server 2010!!!)*
SQL Server, How to removed updates elements from User-Defined Table Type?
===

I have a User-Defined Table Type, lets say `@TT dbo.IntType readonly,`
IntType is batch of `int`, as Primary-Key

    CREATE TYPE [dbo].[IntType] AS TABLE(
    	[T] [int] NOT NULL,
    	PRIMARY KEY CLUSTERED 

I like to do `UPDATE` based on all key(`int`) in `IntType`, and `INSERT` new rows for the key(`int`) not exist in the database (an upsert)

I wonder if theres a easy way to remove the "UPDATED" key(`int`)? Then I can insert the rest.
*(or if you have a super one-line upsert for SQL Server 2010!!!)*