用asp.net编写的网上售书商店 MyPetShop

用asp.net编写的网上售书商店 MyPetShop

create procedure Proc_Sell

@producTId int,

@buyername varchar(50),

@pcount int

as

begin transacTIon tran1

declare @sellername varchar(50)

declare @price float

declare @buyeraddress varchar(100)

declare @buyerphone varchar(50)

save transacTIon op1

--rollback transacTIon op1

commit transaction tran1