Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 578 |
Select from following answers:
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.
Show Correct Answer
Many Interviews |
< Previous :
The !> operator is a comparison operator that c ...
Next > :
You're designing a new SQL Server 2012 query f ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
You're designing a new SQL Server 2012 query for the HR department ...
If you use the BEGIN TRANSACTION statement, then execute 2 insert stat ...
What is missing from the T-SQL statement below for creating and using ...
The transaction isolation level controls the locking and row versionin ...
You're designing a new SQL Server 2012 table that will hold millio ...
As part of a new HR project you're creating several stored procedu ...
Which word is missing from the following statement to create a stored ...
You need to write a new query that will return names from the employee ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...