sql server - SQL insert select @@Identity - Stack Overflow

SQL insert select @@Identity up vote 3 down vote favorite How to use the @@IDENTITY when I use INSERT SELECT ? DECLARE @ENTITYID AS BIGINT INSERT INTO Quiz_QuizQuestion SELECT @ENTITYID, @DIFICULTLEVELCODE ...

stackoverflow.com