SQL Server - Return value after INSERT
SQL Server - Return value after INSERT
SQL Server - Return value after INSERT
Re: SQL Server - Return value after INSERT
No need for a separate SELECT...
```
INSERT INTO table (name)
OUTPUT Inserted.ID
VALUES('bob');
```
This works for non-IDENTITY columns (such as GUIDs) too
```
INSERT INTO table (name)
OUTPUT Inserted.ID
VALUES('bob');
```
This works for non-IDENTITY columns (such as GUIDs) too