Sql Scope_Identity Kullanımı. Fire the trigger and determine what identity values you obtain with the at at identity and scopeidentity functions. In sql server if you ever need to return the value created in an identity column you have several options.
When you update a row scope identiy will not work since the id is already present you just update an existing row. You dont need to use a table variable for output. So an easy way is write to query to get the id based on the same where condition you use to update.
Scopeidentity is to return primary key of record inserted.
Create table dboguidtest guidcolumn uniqueidentifier not null default newsequentialid intcolumn int not null go insert into guidtestintcolumn output insertedguidcolumn. You dont need to use a table variable for output. Select at at identity as identity after sixth insertion scopeidentity as scopeidentity after sixth insertion. For more information see identcurrent transact sql.