Create function fn_GetFileSizeBytes (@filename varchar(1000))
returns bigint
as

BEGIN
DECLARE @objFSys int
DECLARE @Result int
DECLARE @objFile int
DECLARE @Size bigint

set @Size =0

EXECUTE @Result = sp_OACreate 'Scripting.FileSystemObject', @objFSys OUT
EXECUTE @Result = sp_OAMethod @objFSys, 'GetFile', @objFile OUT,@filename
IF @Result <> 0
   begin
  set @Size =-1
   end
else
   begin
  EXECUTE @Result = sp_OAGetProperty @objFile,'Size', @Size OUT
  IF @Result <> 0
    begin
   set @Size =-2
    end
   end
EXECUTE @Result = sp_OADestroy @objFile
EXECUTE @Result = sp_OADestroy @objFSys
return @Size
END

ITPub博客

mssql getfilesize

最新文章