Click here to Skip to main content
15,889,536 members
Home / Discussions / C#
   

C#

 
QuestionStore Key / Value Pair Pin
mark_w_7-Jan-09 5:32
mark_w_7-Jan-09 5:32 
AnswerRe: Store Key / Value Pair Pin
S. Senthil Kumar7-Jan-09 5:47
S. Senthil Kumar7-Jan-09 5:47 
GeneralRe: Store Key / Value Pair Pin
mark_w_7-Jan-09 5:52
mark_w_7-Jan-09 5:52 
Questionretrieving the last increment value in a table Pin
bfis1081377-Jan-09 4:22
bfis1081377-Jan-09 4:22 
AnswerRe: retrieving the last increment value in a table Pin
Wendelius7-Jan-09 4:25
mentorWendelius7-Jan-09 4:25 
GeneralRe: retrieving the last increment value in a table Pin
bfis1081377-Jan-09 4:26
bfis1081377-Jan-09 4:26 
GeneralRe: retrieving the last increment value in a table Pin
Wendelius7-Jan-09 4:30
mentorWendelius7-Jan-09 4:30 
GeneralRe: retrieving the last increment value in a table Pin
Dave Kreskowiak7-Jan-09 6:07
mveDave Kreskowiak7-Jan-09 6:07 
SELECT @@identity
This is typically done at the end of an INSERT to the database, where the database returns the identity of the new row, normally from a stored procedure. You cannot use it any time you want in an attempt to get the id of the last record. The concept just doesn't work that way. For example, what if you had two clients execute that statement on the database at the same time?

You can read up more on it here[^]. Keep in mind, that you're going to have to also read up on what an SQL Session and Scope are to fully understand the material.


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008




QuestionRead a Webpage content. Pin
AksharRoop7-Jan-09 4:13
AksharRoop7-Jan-09 4:13 
AnswerRe: Read a Webpage content. Pin
Colin Angus Mackay7-Jan-09 5:55
Colin Angus Mackay7-Jan-09 5:55 
GeneralRe: Read a Webpage content. Pin
AksharRoop7-Jan-09 19:57
AksharRoop7-Jan-09 19:57 
GeneralRe: Read a Webpage content. Pin
Colin Angus Mackay7-Jan-09 21:37
Colin Angus Mackay7-Jan-09 21:37 
QuestionRe: Read a Webpage content. Pin
AksharRoop7-Jan-09 23:25
AksharRoop7-Jan-09 23:25 
QuestionWhen is goto acceptable? Pin
Dewald7-Jan-09 4:05
Dewald7-Jan-09 4:05 
AnswerRe: When is goto acceptable? Pin
Alan Balkany7-Jan-09 4:15
Alan Balkany7-Jan-09 4:15 
AnswerRe: When is goto acceptable? Pin
Jon Rista7-Jan-09 4:18
Jon Rista7-Jan-09 4:18 
AnswerRe: When is goto acceptable? PinPopular
#realJSOP7-Jan-09 4:40
mve#realJSOP7-Jan-09 4:40 
JokeRe: When is goto acceptable? Pin
Giorgi Dalakishvili7-Jan-09 5:05
mentorGiorgi Dalakishvili7-Jan-09 5:05 
AnswerRe: When is goto acceptable? Pin
Wendelius7-Jan-09 5:05
mentorWendelius7-Jan-09 5:05 
GeneralRe: When is goto acceptable? Pin
DaveyM697-Jan-09 5:16
professionalDaveyM697-Jan-09 5:16 
GeneralRe: When is goto acceptable? Pin
Wendelius7-Jan-09 5:21
mentorWendelius7-Jan-09 5:21 
GeneralRe: When is goto acceptable? Pin
CPallini7-Jan-09 6:12
mveCPallini7-Jan-09 6:12 
JokeRe: When is goto acceptable? Pin
Luc Pattyn7-Jan-09 6:34
sitebuilderLuc Pattyn7-Jan-09 6:34 
AnswerRe: When is goto acceptable? Pin
Guffa7-Jan-09 5:17
Guffa7-Jan-09 5:17 
AnswerRe: When is goto acceptable? Pin
Dan Neely7-Jan-09 5:29
Dan Neely7-Jan-09 5:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.