When you inserting data using SqlCommandBuilder...

10-23-2003

is there a way to retrieve the value of an autoincrement column inserted in
the database?

10-23-2003

Select @@Identity right after the insert. You will get the autoincrement
value.

"Rico Alexander" <> wrote in message
news:...
> is there a way to retrieve the value of an autoincrement column inserted
in
> the database?
>
>

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fetching & Inserting Data into a column of TEXT Data type in SQL server 2000 Using ASP.NET	Bhavesh	ASP .Net	5	07-18-2007 07:39 AM
Fetching & Inserting Data into a column of TEXT Data type in SQL server 2000 Using ASP.NET	Bhavesh	ASP .Net	1	07-17-2007 09:05 AM
Inserting & Fetching Data into a column of TEXT Data type in SQL server 2000 Using ASP.NET	Bhavesh	ASP .Net	0	07-16-2007 11:15 AM
Problem when inserting Data using Arabic or Farsi Language	Fahad	ASP .Net	2	12-27-2003 10:56 AM
Inserting into one table data from 2 tables and some input data.	Renie83	ASP General	1	07-10-2003 08:29 PM