spTempDataRemove

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy



    CREATE procedure [dbo].[spTempDataRemove] (@ID uniqueidentifier)
                as
        set nocount on;

                    delete from dbo.TempData where ID = @ID;

                    -- Doing this on the delete updates the db
                    delete from dbo.TempData where getutcdate() > Expiration;