How we can check for file exitence in a specified folder using TSQL

02 September 2010 · TSQL · Article · 60 visite

How we can check for file exitence in a specified folder using TSQL. One option to validate that a file exists or not is to use the master.dbo.xp_fileexist extended stored procedure.

 

SET NOCOUNT ON

declare @fileexist int
exec xp_fileexist 'c:\appoggio\bTreeDoc\-1-0000008-0001834.pdf', @fileexist OUTPUT
select @fileexist
if @fileexist >0
	BEGIN
		print 'file exists..'
		
	END
else
BEGIN
	print 'file doesn''t exists....'

END

How we can check for file exitence in a specified folder using TSQL

Navigazione

Contatti