Buy Questpond's video subscriptions on
huge discount
.
Online: 2518
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
which inbuilt function can be used to know the id value of the last row that was inserted, rather than re-run another query just to get the maximum id value ?
Posted by
Bandi
on 8/29/2017 | Category:
Sql Server Interview questions
| Views: 3807 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
ROWCOUNT
@@IDENTITY
@@ROWCOUNT
SCOPE_IDENTITY
All Above
Scope_identity() returns the last identity value generated for any table in the current session and the current scope
Show Correct Answer
|
Alert Moderator
Bookmark It
< Previous :
which of the following clause is used to return SQ ...
Next > :
The table includes a DATETIME column named EventTi ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
The table includes a DATETIME column named EventTime that stores the d ...
Here is the JSON string DECLARE @jsonInfo VARCHAR(MAX) SET @jsonInf ...
What is wrong with the below T-SQL batch statement ? @find varchar( ...
The id_num column of the below table is an auto increment column but w ...
In which order should the below clauses be used in the query that work ...
Which Path parameter in the below JSON code snippet would NOT result i ...
You have below table CREATE TABLE Inventory (ItemID int NOT NULL PR ...
How to format datetime value to Mon.YY ?
Latest Interview Questions
Which one is Server type state management?
Which one is Client type state management?
Disadvantages of using LINQ?
What will be the output of --Input Script --Declare a sample table ...
Extension when LINQ to SQL is used in C#?
What will be the output of DECLARE @string VARCHAR(20) = 'Hell ...
What is Live Unit Testing?
What will be the output of the below TSQL Script? DECLARE @t TABLE( ...
More ...
Show Correct Answer