No announcements
Found 2929219 threads
-
1 VotesScope_Identity vs @@identity
I am reading your book "SQL Server 2008 Internals".Answered | 3 Replies | 11135 Views | Created by janets20 - Sunday, June 20, 2010 1:54 AM | Last reply by janets20 - Monday, June 21, 2010 9:30 PM
-
0 Votes
The usage of Ident_current
Then you'll just need to catch the latest identity value created in that session using SCOPE_IDENTITY() to know its session id.Answered | 4 Replies | 1244 Views | Created by brianlee1982 - Tuesday, August 5, 2014 2:08 AM | Last reply by Aalamjeet Rangi - Saturday, August 9, 2014 5:34 AM -
0 Votes
temporary tables IDENT_CURRENT
The problem with Ident_Current(), @@IDENTITY and Scope_Identity() is that they can only deal with single values.Answered | 4 Replies | 2603 Views | Created by Tharindu Dhaneenja - Friday, April 5, 2013 7:11 AM | Last reply by gvee - Friday, April 5, 2013 8:33 AM -
0 Votes
What is Difference Between Count(), Scope_identity(), @@identity
SCOPE_IDENTITY() can only be used to capture the identity for a single INSERT.Answered | 5 Replies | 1621 Views | Created by Arz Muhammad Brohi - Sunday, June 29, 2014 10:05 AM | Last reply by scott_morris-ga - Monday, June 30, 2014 1:17 PM -
0 Votes
SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY not working with Linked Server
The scope of the @@IDENTITY function is current session on the local server on which it is executed.Unanswered | 2 Replies | 9571 Views | Created by Varinder Sandhu - Wednesday, January 19, 2011 6:32 AM | Last reply by Uri Dimant - Wednesday, January 19, 2011 7:30 AM -
0 Votes
what is scope Identity ?
scope identity Returns the last identity value inserted into an identity column in the same scope.Answered | 3 Replies | 5764 Views | Created by prateekalmighty - Thursday, March 4, 2010 6:08 AM | Last reply by Dinesh Asanka - Thursday, March 4, 2010 7:08 AM -
0 Votes
# IDENT_CURRENT # # @@IDENTITY # # SCOPE_IDENTITY #
User-1786411686 posted Use SCOPE_IDENTITY(). works in all scenarios.Answered | 5 Replies | 56 Views | Created by Anonymous - Monday, November 6, 2006 7:25 AM | Last reply by Anonymous - Tuesday, November 7, 2006 12:02 PM -
0 Votes
- SCOPE_IDENTITY --
.), the SCOPE_IDENTITY can be incorrect.Answered | 7 Replies | 5026 Views | Created by Jaylem - Thursday, February 25, 2010 10:26 AM | Last reply by JenisysJohnToo - Tuesday, August 24, 2010 8:12 PM -
0 Votes
Next Identity
You can reseed the identity value if you need to create a "hole".Answered | 5 Replies | 3329 Views | Created by Tiago Braga Machado - Tuesday, March 27, 2012 8:00 PM | Last reply by Vishal Gajjar - Wednesday, March 28, 2012 7:47 AM -
0 Votes
@@Identity not returning newly Inserted record ID
scope_identity() works wherever @@identity does.Answered | 9 Replies | 2268 Views | Created by -kit - Wednesday, June 25, 2014 11:58 PM | Last reply by Erland Sommarskog - Thursday, June 26, 2014 9:59 PM -
0 Votes
retriving last identity value from table?
Please see this link SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record In ...Answered | 3 Replies | 5617 Views | Created by pswasule - Sunday, March 21, 2010 10:53 AM | Last reply by Naomi N - Sunday, March 21, 2010 3:45 PM -
0 Votes
SCOPE_IDENTITY()
SCOPE_IDENTITY() has nothing to do with the primary key.Answered | 1 Replies | 4619 Views | Created by Mattaniah - Tuesday, June 8, 2010 6:52 PM | Last reply by Abdshall - Tuesday, June 8, 2010 6:54 PM -
0 Votes
use of scope_identity(), @@identity and ident_current
It works fine now.Answered | 4 Replies | 52 Views | Created by Anonymous - Tuesday, January 19, 2010 4:48 AM | Last reply by Anonymous - Tuesday, January 19, 2010 5:35 AM -
1 Votes
Scope safety of IDENT_CURRENT
As you cannot control what others are doing in parallel, it's not guaranteed that this will work.Answered | 7 Replies | 783 Views | Created by Matt S- - Wednesday, March 2, 2016 12:52 PM | Last reply by davidbaxterbrowne - Wednesday, March 2, 2016 5:12 PM -
0 Votes
check ident for all tables with an identity column
,IDENT_CURRENT(''?'')'Answered | 2 Replies | 2210 Views | Created by Darin Horton - Friday, August 16, 2013 3:07 PM | Last reply by Sarat (SS) - Friday, August 16, 2013 5:42 PM -
0 Votes
SCOPE_IDENTITY
Is Scope_Identity() only valid if table has int key value.Answered | 3 Replies | 8458 Views | Created by Sanyon_d - Monday, March 21, 2011 5:06 AM | Last reply by KJian_ - Monday, March 28, 2011 2:47 AM -
0 Votes
HOW CAN I GET THE IDENTITY COLUMN OF A TABLE
Visit my SQL Server Compact blogAnswered | 1 Replies | 7110 Views | Created by Kath07 - Wednesday, June 22, 2011 5:26 AM | Last reply by ErikEJ - Wednesday, June 22, 2011 8:22 AM -
0 Votes
Returning @@IDENTITY issue - Multi user application
If i use @@identity to both @VAR1,@VAR2 I will get the identity of their table TABLE1 and TABLE2 accordingly.Answered | 12 Replies | 4587 Views | Created by Mellinda Dealy - Monday, August 31, 2009 7:37 AM | Last reply by Mellinda Dealy - Monday, August 31, 2009 9:16 AM -
0 Votes
What are difference between @@IDENTITY, SELECT SCOPE_IDENTITY(), SELECT IDENT_CURRENT in SQL Server?
still the difference between @@IDENTITY and SCOPE_IDENTITY() is not clear. what they try to mean global scope and local scope ?Answered | 3 Replies | 1597 Views | Created by Mou_kolkata - Wednesday, November 16, 2016 12:47 PM | Last reply by SharadVerma - Wednesday, November 16, 2016 1:02 PM -
0 Votes
Insert using SCOPE_IDENTITY()
Thanks, I found that scope_identity() and @@identity only work once within a given session( I hope session is the right term).Answered | 13 Replies | 11249 Views | Created by Mr Shaw - Friday, April 16, 2010 11:17 AM | Last reply by Mr Shaw - Friday, April 16, 2010 1:47 PM - Items 1 to 20 of 2929219 Next ›
No announcements
