Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
You're designing a new query that will eventually be used by a new software application. It's important that the application knows the id value of the last row that was inserted. Rather than re-run another query just to get the maximum id value, your friend has told you to include an inbuilt function. What might that function be?
SCOPE_IDENTITY
ROWCOUNT
@@ROWCOUNT
@@IDENTITY
That was the correct answer, well done!
Sorry, that was the wrong answer
SCOPE_IDENTITY is the best answer. Although you could use @@IDENTITY, you need to be careful here, since it's across scopes. You could get a value from a trigger, instead of your current statement.
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2020
All rights reserved