增加后删除存储过程

CREATE PROCEDURE [dbo].[UP_EC_JOB_CreatePurgeUrlFromMiddle]
AS    
SET NOCOUNT ON    

DELETE FROM dbo.Purge_Url_Middle
OUTPUT
    DELETED.Url,
    DELETED.InUser,
    DELETED.[Priority]
INTO dbo.purge_url
(
    url ,
    EditUser ,
    [Priority]    
)
WHERE BeginDate <= GETDATE()

GO