ALTER TRIGGER TempProcTrig ON Table_temp2 AFTER insert AS BEGIN declare @TempIdentity int set @TempIdentity =scope_identity() insert Table_Temp(TempID) values(@TempIdentity) END
ALTER TRIGGER TempProcTrig ON Table_temp2 AFTER insert AS BEGIN insert Table_Temp(TempID) SELECT TempID FROM inserted END
Alter Table Table_temp2 Add TempId Int IDENTITY(1,1) Not null
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)