How do I get the index in an insert?

J

Jon Davis

I have a numerical indexer in a table. How do I get the new index field
value when inserting a new record when using OleDbCommand?

Jon
 
J

Jon Davis

(I found the answer in another group. See @@IDENTITY and SCOPE_IDENTITY() in
Books Online for SQL Server.)

Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 How to sort an index created in Word 2013 0
insert data in an access db with C# (update) 1
How to update a dataset table row I have previously added ? 1
How to get the index selected in the datagrid table 1
VBA - retrieve data on last create named range from previous inserted named range 0
Text files and Linq to Entities 0
Count Values in a Range, Not Formulas 2
How to get a value of primary key for a newly inserted mdb record? 3

Top