Insert OrderNo into Order Details Table

Question

User-1520784531 posted

I've 2 tables, namely Order and Order Details. 

In my Order Table, I've a primary key name OrderNo with an Identity increment value. Wherelse my Order Details contain an OrderNo from the Order Table.

How do I insert the OrderNo in the OrderDetails Table? 

Answer 1

User1458583585 posted

you can create a procedure.

create procedure orderOpration
(
	@name nchar(10),
	@fname varchar(100)
)
as 
begin
set 
insert into ordermaster (name) values(@name)
insert into orderdetails (fname,orderid)values(@fname,IDENTITY)
end

you can change variable for your requierment..

Answer 2

User3866881 posted

In my Order Table, I've a primary key name OrderNo with an Identity increment value. Wherelse my Order Details contain an OrderNo from the Order Table.

How do I insert the OrderNo in the OrderDetails Table? 

Hello：）

Another way is everytime when you use SqlCommand to insert a record into Order Table successfully, Just use "select top OrderNo from Order order by OrderNo desc" to get the latest single OrderId, and then use it as a value parameter to call OrderDetails with.

Thx

Answer 3

User-654786183 posted

Try this in your stored procedure

DECLARE @INSERTETDID INT

INSERT INTO [SearchEngine].[dbo].[searchItems]
([searchItem])
VALUES
(@searchItem)

SELECT @INSERTETDID=SCOPE_IDENTITY()

INSERT INTO [SearchEngine].[dbo].[urls]
([queryId])
VALUES
(@INSERTETDID)