Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Executing SQL

Status
Not open for further replies.
paulcooke

paulcooke

Programmer
Dec 11, 2003
35
0
0
GB
I'm creating my SQL on the fly based on data entered
but I need to return the ID or auto number of the row once it has been entered. Need this to add rows to other tables but use the id as the link. How do i get the id created?
Many thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
98
Andrzejek
Andrzejek
BJZeak
  • Locked
  • Question
SQL Solution?
Replies
1
Views
41
Darrylles
Darrylles
03Explorer
  • Locked
  • Question
Execute SQL causes IDENTITY issue with one statement but not other
Replies
4
Views
60
03Explorer
03Explorer
Mke85
  • Locked
  • Question
VBA, SQL to select and then delete records 1
Replies
16
Views
210
dhookom
dhookom
03Explorer
  • Locked
  • Question
Nested Loops each based on SQL Server Linked table queries (SLOW and INCONSISTENT for run time) 1
Replies
11
Views
104
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top