Gerrit Mantel
Programs SQL_SCALAR_FUNCTION - fun_FileProperty_Size

Main program

Namefun_FileProperty_Size
Type_descSQL_SCALAR_FUNCTION
CommentSQLServer User-Defined Function

PURPOSE
Return the size (in bytes) of a given file.

Return value (BIGINT):
-1 - File does not exist
positive big integer - Size of the file in bytes

EXAMPLES
SELECT dbo.fun_FileProperty_Size('C:\oneTouch_drive.cvf')
4

HISTORY
2000-01-01 - Created function
2014-11-20 - Changed @size type from varchar(20) to bigint
- Introduced sp_OADestroy @ofile
2024-02-09 - Changed history table

TAGS
<program>
<description>Return the size (in bytes) of a given file</description>
<generic>1</generic>
<author>Gerrit Mantel</author>
<created>2000-01-01</created>
<lastmodified>2024-02-09</lastmodified>
</program>
DescriptionReturn the size (in bytes) of a given file
Minversion
Generic1
AuthorGerrit Mantel
Created2000-01-01 00:00:00
Lastmodified2024-02-09 00:00:00
Xp_cmdshell0
Ole_automation1
Subprogram_cnt0
Sourcecode