Please start any new threads on our new site at https://forums.sqlteam.com. 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 

AskSQLTeam
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.

lrthomas
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

spirit1
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
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page
   

- Advertisement -