delete file

DECLARE @cmd VARCHAR(1000);

DECLARE @filePath VARCHAR(255) = 'C:\tt\tt.zip';

DECLARE @output TABLE (output VARCHAR(1000));





SET @cmd = 'del "' + @filePath + '"';





INSERT INTO @output

EXEC xp_cmdshell @cmd;





SELECT output

FROM @output;