I have two tables Orders and Orders_detail.
The Orders table has OrderID as the primary key.
The Orders_detail table has the OrderID as a foreign key.
In my ASP application, I want to insert a record into both tables. How do I get the OrderID from the Orders table, so that I can insert the data into my Orders_detail table. In Oracle, I would have the OrderID set as a sequence and then use the OrderId.currval for the insert into the Orders_detail table. I'm not sure how to do this in Sql Server 2005. Can anyone help ?

Follow the link you will get your solution.
http://p2p.wrox.com/topic.asp?TOPIC_ID=67957

You will also need to study how to access sql stored procedure from asp code, because you want get order id back and pass it to detail table.

urt