Create proc asp_insert_Persons_order
(
@FirstName varchar(100),
@LastName varchar(100),
@OrderNumber int,
@OrderDetails varchar(100)
)
AS
BEgin
Begin tran
Declare @Id int
Insert into Persons(FirstName, LastName ) values (@FirstName,@LastName )
Select @Id=@@Identity
Insert into Orders values (@OrderNumber ,@OrderDetails ,@Id)
Commit tran
END