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;