USP_TEMPDATA_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BINARYDATA	image	IN
@TEXTDATA	ntext	IN
@TIMESPAN	time	IN

Definition

Copy



CREATE procedure dbo.USP_TEMPDATA_ADD
(
    @ID uniqueidentifier,
    @BINARYDATA image,
    @TEXTDATA ntext,
    @TIMESPAN time
)
as
begin
    if ((select COUNT(1) from dbo.TempData where ID = @ID) = 0)
    begin
        insert into dbo.TempData (ID, BinaryData, TextData, Expiration) values (@ID, @BINARYDATA, @TEXTDATA, GETUTCDATE() + convert(datetime,@TIMESPAN));
    end
    else
    begin
        update    [dbo].[TempData]
        set        [BinaryData] = @BINARYDATA, 
                [TextData] = @TEXTDATA, 
                [Expiration] = GETUTCDATE() + convert(datetime,@TIMESPAN)
        where    [ID] = @ID
    end
end