T-SQL FileExist
07-Jun-1313 Leave a comment
File Exits
/*
SELECT dbo.myFileExist ('c:\Temp\Test.txt') AS FileExists
SELECT dbo.myFileExist ('c:\Temp\Test1.txt') AS FileExists
*/
ALTER FUNCTION dbo.myFileExist (@FileName varchar(100))
RETURNS int
AS
BEGIN
DECLARE @FileExists int
EXECUTE master.dbo.xp_fileexist @FileName, @FileExists OUT
RETURN @FileExists
END
Stephen Shakespeare 