spTempDataAdd

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@Data	image	IN
@Text	ntext	IN
@Expiration	datetime	IN

Definition

Copy




CREATE procedure dbo.spTempDataAdd (@ID uniqueidentifier, @Data image, @Text ntext, @Expiration datetime)
            as
      begin
                set nocount on;

                if ((select COUNT(1) from dbo.TempData where ID = @ID) = 0)
                begin
                    insert into dbo.TempData (ID, BinaryData, TextData, Expiration) values (@ID, @Data, @Text, @Expiration);
                end
                else
                begin
                    update    [dbo].[TempData]
                    set        [BinaryData] = @Data, 
                            [TextData] = @Text, 
                            [Expiration] = @Expiration
                    where    [ID] = @ID
                end            
end