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.
| 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 |
 |
|
|
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 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
Article: Returning @@IDENTITY back to an ASP Page