Use SQL Server to determine whether a file exists and then delete it (details)

In SQL Server, you can use the internal Stored Procedure xp_fileexist to determine whether a file exists. If yes, you can use xp_exist shell to delete the file. In addition to determining whether a file exists, xp_fileexist can also determine whether a folder exists. The following two examples are used.

Delete a file stored procedure
ALTER proc [dbo]. [delFile_P]
(@ Path nvarchar (200 ))
As
Declare @ result int
Exec master. dbo. xp_fileexist @ path, @ result out -- the path can contain spaces.
If @ result = 1 -- 1 the file exists, and 0 does not exist.
Begin
-- If the path contains spaces, the space character must be replaced before shell execution and enclosed in double quotation marks.
Set @ path = 'del '+ replace (@ path ,'','""')
Exec master. dbo. xp_mongoshell @ path
End
Call the Stored Procedure exec MIS. dbo. delFile_P 'f:/Internet Explorer 6 green/install. Log'