Mssqlsql returns the inserted ID

Mssqlsql returns the inserted ID

Mssql SQL returns the inserted ID

Mssql SQL returns the inserted id

Set xact_abort on
Begin tran
Declare @ id int
Insert table a values ('small 5 ')

Select @ id = scope_identity ()
Insert table B values (@ id,'ll ')
Insert table c values (@ id, 'ee ')
Commit

//

Create trigger tri _ Table
On Table
For insert
As
Begin
Declare @ id int
Select @ id = id from isnerted
Insert table B values (@ id,'ll ')
Insert table c values (@ id, 'ee ')
End
//

Create table dbo. tbtest (
Id int identity (1, 1) not null
, Value varchar (50)
)

-- The following statement is executed several times, which can be very effective.

Declare @ id int -- get the new id

Insert into dbo. tbtest (value) values ('aaa ')

Set @ id = scope_identity ()

Select @ id