16 lines
398 B
Transact-SQL
16 lines
398 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_auctionarticle]
|
|
@item_uid [uniqueidentifier],
|
|
@bid_auth_uid [uniqueidentifier],
|
|
@bid_uid [uniqueidentifier],
|
|
@bidder nvarchar(15),
|
|
@bid_price int
|
|
as begin
|
|
set nocount on
|
|
update dbo.AuctionListTable
|
|
set bidder_name = @bidder,
|
|
bid_price = @bid_price,
|
|
bidder_auth_uid = @bid_auth_uid,
|
|
bidder_uid = @bid_uid
|
|
where item_uid = @item_uid
|
|
|
|
end
|