All Questions
2 questions
3
votes
2
answers
2k
views
SQL Server 2012 scope_identity advise
I created a stored procedure in SQL Server 2012 and I have used scope_identity to get identity column's value but in my case I do not know is this correct or not please help
CREATE PROCEDURE ...
- 1,838
44
votes
6
answers
187k
views
Inserting into Oracle and retrieving the generated sequence ID
I have a handful of raw SQL queries for SQL Server which use SCOPE_IDENTITY to retrieve the generated ID for a specific INSERT immediately after that INSERT occurs all in one execution…
INSERT into ...
- 2,497