 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
CodeSnip: How to Get Id of the Record Using ASP.NET and SQL Server 2000
|
Published:
29 Jun 2006
|
Abstract
In this article Sushila demonstrates how to retrieve the ID of a newly added record using ASP.NET and SQL Server 2000. The author makes use of SCOPE_IDENTITY() function to achieve the functionality. |
 |
by Sushila Bowalekar Patel
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
36501/
78
|
|
|
|
| Introduction |
In this code snippet we will examine how to get Id of the
newly added record using ASP.NET and SQL Server 2000.
We come across cases where we have to get the Id for the
newly inserted record. The Id in our case is an IDENTITY field. The retrieval
of this Id can be done in a variety of ways. In this article we will see one
of the techniques on how we can achieve this retrieval. We will use the TSQL
function, SCOPE_IDENTITY(), that gives us the last
identity value generated in the current scope of the current process.
|
|
|
|
User Comments
Title:
thanks
Name:
vibhu singh
Date:
2007-05-01 4:20:09 AM
Comment:
thanks. i am a student. i was searching code for insert data in sql table. your site provide perfect solution for my search. thanks for this help.
|
Title:
help
Name:
amit07
Date:
2007-03-30 9:58:25 AM
Comment:
hi,
can u plz clear the diff b/w scope_identity() and @@identity
more.
|
Title:
Excellent
Name:
From Iran
Date:
2007-03-28 5:36:09 AM
Comment:
This Tutorial was one of the rare clear ones on the NET excellent job
|
Title:
Thanks
Name:
Hooman
Date:
2007-03-28 5:13:04 AM
Comment:
Thank you, You Made my Day
|
Title:
Thanks Thanks Thanks Thanks Thanks
Name:
Desperate
Date:
2007-02-22 10:28:39 PM
Comment:
Man, you have no idea, you saved my job!
|
Title:
Thanks
Name:
Swinkster
Date:
2007-02-13 9:17:43 AM
Comment:
Thank you! Well written example.
|
Title:
a very good one...
Name:
Genie
Date:
2006-12-26 9:58:10 PM
Comment:
Thanks a lot...
i've been searching for this the whole day, but now i got it :)
|
Title:
Very Good Code
Name:
M.Anwar Iqbal Khan
Date:
2006-12-03 7:13:54 AM
Comment:
That kind of code i am looking for in internet, very good code. Thanks.
|
Title:
Muchas Gracias
Name:
Peter
Date:
2006-11-28 3:29:33 AM
Comment:
Thanks, just what i needed!
|
Title:
great article
Name:
cake
Date:
2006-09-27 10:14:38 AM
Comment:
thanks alot!
|
Title:
thanks
Name:
surya bhan
Date:
2006-09-27 4:03:50 AM
Comment:
very good
|
Title:
Thanks
Name:
Dave London
Date:
2006-08-21 12:45:40 PM
Comment:
Good article. Until recently I wasn't aware of the difference myself. Your solution is the one I would recommend as @@indentity is not thread safe and it is better practice to use SCOPE_IDENTITY() just in case triggers are added to the table at a later stage.
|
Title:
Good snippit
Name:
toffer
Date:
2006-08-10 5:34:26 AM
Comment:
great article... exactly what i need ... :)
|
Title:
Thanks
Name:
TonyM
Date:
2006-08-08 4:50:49 PM
Comment:
Excellent Example. Thanks for the snippets, explanations and example. I searched high and low for a good example, glad I found this one!
|
Title:
Thank you!
Name:
terryh
Date:
2006-07-28 9:25:26 PM
Comment:
Finally, exactly what I needed. Why is this stuff so hard to find?...oh well...
|
|
|
|
|
|
