Retreiving identity value after row inserted in SQL Server table

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

Retreiving identity value after row inserted in SQL Server table

Author

Message

stephen

Posts: 4

Posted: 09/29/2005, 10:30 PM

Hi there,

How can I retrieve the identity of a row inserted to a Sql Server table with an identity column?

I have tried the suggestions in previous posts but these don't work in ASP.NET
_________________
Regards,
Stephen

www.opacity.com.au....websites, we make it that simple!

Abs

Posted: 10/05/2005, 3:09 PM

Hi,

I have done this using SELECT @@IDENTITY

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login