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;