示例:
IF OBJECT_ID('FileExists','FN') IS NOT NULL
DROP FUNCTION FileExists
go
Create function FileExists(@filepath varchar(500))
RETURNS INT
as
begin
DECLARE @result INT
SET @filepath='D:\'+@filepath
EXECUTE master..xp_fileexist @filepath,@result OUTPUT
RETURN @result
End
go
使用案例:
SELECT TOP 10 * FROM dbo.PicFolder WHERE dbo.FileExists(img)=1 --查找物理文件存在的记录