MS SQL Server Last Inserted ID
Try this one -
DECLARE @ID BIGINTINSERT INTO dbo.TABLE_ID (Table_NAME) SELECT 'Table_Products'SELECT @ID = SCOPE_IDENTITY()INSERT INTO dbo.Table_Products (ID, Product_Name)SELECT @ID, 'SomeProduct'
You can use an insert statement with the output clause to generate a new Common_ID. Using insert ... select, you can specify that ID in an insert operation:
declare @Common_ID as table(ID int)insert Table_ID (Table_Name)output inserted.Common_ID into @Common_IDvalues ('Table_Products')insert Table_Products (ID, Product_Name)select ID, 'Some Product'from @Common_ID
Use SCOPE_IDENTITY() after ur insert statementto get the last inserted id.
DECLARE @Product_Id intINSERT INTO TABLE_ID (Table_NAME) VALUES (Table_Products);SELECT @Product_Id=SCOPE_IDENTITY();Insert INTO Table_Products (ID, Product_Name)VALUES (ID from TABLE_ID, 'SomeProduct')