USP_DATAFORMTEMPLATE_PRELOAD_AUCTIONPACKAGETOAUCTION
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@EVENTAUCTIONID | uniqueidentifier | IN | |
@EVENTAUCTIONNAME | nvarchar(100) | INOUT | |
@BASECURRENCYID | uniqueidentifier | INOUT | |
@TRANSACTIONCURRENCYID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_AUCTIONPACKAGETOAUCTION
(
@EVENTAUCTIONID uniqueidentifier,
@EVENTAUCTIONNAME nvarchar(100) = null output,
@BASECURRENCYID uniqueidentifier = null output,
@TRANSACTIONCURRENCYID uniqueidentifier = null output
)
as
set nocount on;
select
@EVENTAUCTIONNAME = EVENT.NAME,
@BASECURRENCYID = EVENT.BASECURRENCYID,
@TRANSACTIONCURRENCYID = EVENT.BASECURRENCYID
from dbo.EVENT
where EVENT.ID = @EVENTAUCTIONID;