订单生成的过程：
CREATE proc Order_ip_Insert
@parm varchar(10),
@parm2 type(length),
.......
AS
Begin
Begin Transaction Insert
Insert ......
If @@error !=0
Begin
Rollback Transaction Insert
Return -1
End
Commit Transaction Insert
Return @@IDENTITY
End
Go
记录订单商品的过程
CREATE proc OrderProduct_ip_Insert
@OrderId int,
@Product type(length),
.......
AS
Begin
Begin Transaction Insert
Insert ......
If @@error !=0
Begin
Rollback Transaction Insert
Return -1
End
Commit Transaction Insert
Return @@IDENTITY
End
Go