spTempDataFetch
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure [dbo].[spTempDataFetch] (@ID uniqueidentifier)
as
set nocount on;
delete from dbo.TempData where getutcdate() > Expiration;
select BinaryData, TextData from dbo.TempData where ID = @ID;