Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Returning @@IDENTITY back to an ASP Page

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2000-08-17 : 19:30:46
Gareth writes "Hi, I'd be so relieved if you could sort this out . . . I'm trying to get the value of @@IDENTITY from SQL Server into an ASP variable (via a recordset) - however I get an ASP error reporting that the value in the recordset (selected as 'ident') can't be found. What's going on . . . Thanks!"

Article Link.

Starting Member

1 Post

Posted - 2008-05-28 : 12:28:19
I dont use ASP I use vb 2005. How would I get the answer to the @@identity in my vb2005 code?

Lonnie R Thomas
Go to Top of Page

Cybernetic Yak Master

11752 Posts

Posted - 2008-05-28 : 12:48:25
with dataset and dataadapter or executescalar method of sqlcommand object.
if you're going to use executescalar then you have to return with "select @@identity" in your sproc.

also use scope_identity() instead of @@identity

Causing trouble since 1980
Speed up SSMS development: <- version 1.0 out!
Go to Top of Page

- Advertisement -