USP_DATAFORMTEMPLATE_EDITLOAD_TAXONMERCHANDISE
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | |
@DATALOADED | bit | INOUT | |
@TSLONG | bigint | INOUT | |
@MERCHANDISEPRODUCTID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_TAXONMERCHANDISE
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@MERCHANDISEPRODUCTID uniqueidentifier = null output
)
as
set nocount on;
set @DATALOADED = 0
set @TSLONG = 0
select
@DATALOADED = 1
from dbo.TAX
where TAX.ID = @ID
return 0;