Gerrit Mantel
 |
Programs | SQL_SCALAR_FUNCTION - fun_FolderExist |  |
 |
 |
 |
| Name | fun_FolderExist |
| Type_desc | SQL_SCALAR_FUNCTION |
| Comment | SQLServer User-Defined Function PURPOSE Check if folder exists. Return value (BIT): 0 (False) - Folder does not exist 1 (True) - Folder exists EXAMPLES SELECT dbo.fun_FolderExist('C:\Program Files') 1 SELECT dbo.fun_FolderExist('C:\xxxx') 0 -- IIF is available starting with SQL Server 2012 PRINT IIF(dbo.fun_FolderExist('C:\Program Files')=1,'Yes','No') Yes HISTORY 2015-11-24 - Created function 2024-02-09 - Changed history table 2026-01-23 - Changed return value type to BIT TAGS <program> <description>Check if folder exists</description> <generic>1</generic> <author>Gerrit Mantel</author> <created>2015-11-24</created> <lastmodified>2026-01-23</lastmodified> </program> |
| Description | Check if folder exists |
| Minversion | |
| Generic | 1 |
| Author | Gerrit Mantel |
| Created | 2015-11-24 00:00:00 |
| Lastmodified | 2026-01-23 00:00:00 |
| Xp_cmdshell | 0 |
| Ole_automation | 1 |
| Subprogram_cnt | 0 |
| Sourcecode |  |