Download
100% FREE
Office Document APIs for .NET
Online: 663
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
>
Forums
>
Sql Server
>
Loading ...
What is difference between SCOPE_IDENTITY & IDENT_CURRENT
Posted by
Kundan64
under
Sql Server
on 1/11/2013 |
Points: 10
| Views : 1535 | Status :
[Member]
| Replies : 1
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
What is difference between SCOPE_IDENTITY & IDENT_CURRENT, and from where these function taking value?
Reply
|
Reply with Attachment
Alert Moderator
Responses
Posted by:
Raja_89
on: 1/12/2013
[Member]
Starter
|
Points: 25
0
Hai
Scope_Identity
It returns the last identity value generated for any table in the current session the current scope
Example
select scope_identity()
IDENT_CURRENT
It returns the last identity value generated for a specific table in any scope and session.
It is not affected by any session ,scope
Example
I have created a table called eno which has some values eid was identity column
If i want to see the ldentity value for eno
select ident_current('eno')
Kundan64
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Login to post response
Latest Posts
I Want to Do a multiple selector on ASPnet MVC
(0)
New
Get all materials of parent and its children in an array except for few
(0)
Container in Media Query
(0)
How to send keys to specified app with title?
(1)
NullReferenceException when adding list
(0)
How to run a VB.NET exe in the backend on Azure VM server?
(0)
Null Reference Exception
(0)
How do you parse the Subject Alternate Names from an X509Certificate2?
(0)
More ...