InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 04:52:51 GMT20http://www.sqlservercentral.com/Forums/Topic788067-145-1.aspxselect @@identity returns last inserted value of the current session. I think your prepared statement is run in one session and the select @@identity in another.Thu, 17 Sep 2009 04:05:08 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic788067-145-1.aspxSwitch to using the OUTPUT clause instead. It WILL be a single statement and won't have the vulnerabilities that @@identity has.[code]Insert MyTable(Mycolumns)Output inserted.MyIdentityselect MyColumnValue[/code]Tue, 15 Sep 2009 06:53:09 GMTMatt Miller (#4)http://www.sqlservercentral.com/Forums/Topic788067-145-1.aspxHi!We are porting a database from SQL Server 2000 to SQL Server 2008 and server is Weblogic server 8.1 SP6. Earlier for SQl 2000 we used jdriver and now we upgraded to sqljdbc 1.2 driver. We have problems with insert staments followed by an SELECT @@IDENTITY. SQLException has raised The statement did not return a result set.We are using prepared statement. Please give me suggestions to resolve this issue.Thanks in advanceAlluTue, 15 Sep 2009 05:19:37 GMTsunjavasri