Gerrit Mantel
 |
Programs | SQL_SCALAR_FUNCTION - fun_FileProperty_Archivebit |  |
 |
 |
 |
| Name | fun_FileProperty_Archivebit |
| Type_desc | SQL_SCALAR_FUNCTION |
| Comment | SQLServer User-Defined Function PURPOSE Return the Archive bit of one file. Return value (BIT): 1 = Archive bit is true 0 = Archive bit is false NULL = File does not exist Member Binary Decimal ---------- ------------- ------- ReadOnly 1 1 Hidden 10 2 System 100 4 Directory 10000 16 Archive 100000 32 <====== Device 1000000 64 Normal 10000000 128 Temporary 100000000 256 SparseFile 1000000000 512 Compressed 10000000000 2048 Offline 100000000000 4096 Encrypted 1000000000000 16384 EXAMPLES SELECT dbo.fun_FileProperty_Archivebit ('D:\MSSQL\genre.txt') 1 SELECT dbo.fun_FileProperty_Archivebit ('C:\xxx.txt') NULL HISTORY 2000-01-01 - Created function 2014-11-20 - Unknown change 2024-02-09 - Changed history table TAGS <program> <description>Return the archive bit of a file</description> <generic>1</generic> <author>Gerrit Mantel</author> <created>2000-01-01</created> <lastmodified>2024-02-09</lastmodified> </program> |
| Description | Return the archive bit of a file |
| Minversion | |
| Generic | 1 |
| Author | Gerrit Mantel |
| Created | 2000-01-01 00:00:00 |
| Lastmodified | 2024-02-09 00:00:00 |
| Xp_cmdshell | 0 |
| Ole_automation | 1 |
| Subprogram_cnt | 0 |
| Sourcecode |  |