How can I assign inserted output value to a variable in sql server? [duplicate]

Question

Possible Duplicate:
SQL Server Output Clause into a scalar variable

DECLARE @id int INSERT INTO MyTable(name) OUTPUT @id = Inserted.id VALUES('XYZ') 

I am trying like above. How is it possible?

Answer 1

Use table variable to get id

DECLARE @id int DECLARE @table table (id int) INSERT INTO MyTable(name) OUTPUT inserted.id into @table VALUES('XYZ')  SELECT @id = id from @table