Gerrit Mantel
Programs MSSQL modules (43 recs)    
NameType descDescriptionMinversionGenericAuthorCreatedLastmodifiedUpdate statusXp cmdshellOle automationSubprogram cntInfoSourcecode
fun_CreateFolderSQL_SCALAR_FUNCTIONCreate folder1Gerrit Mantel2020-09-022026-01-23Recently modified010
fun_date_arraySQL_TABLE_VALUED_FUNCTIONReturn dates of every given interval on current given period1Gerrit Mantel2015-12-022024-02-09000
fun_date2isoweekSQL_SCALAR_FUNCTIONReturn the ISO weeknumber for a given date1Gerrit Mantel2004-12-072024-02-09000
fun_date2monthSQL_SCALAR_FUNCTIONReturn the description of the month for a given date1Gerrit Mantel2004-12-042024-02-09000
fun_date2weekdaySQL_SCALAR_FUNCTIONReturn the description of the weekday for a given date1Gerrit Mantel2004-12-072024-02-09000
fun_DeleteFileSQL_SCALAR_FUNCTIONDelete given file(s)1Gerrit Mantel2017-10-102026-01-23Recently modified010
fun_DeleteFolderSQL_SCALAR_FUNCTIONDelete given folder(s)1Gerrit Mantel2017-10-102026-01-23Recently modified010
fun_DriveProperty_FreeSpaceSQL_SCALAR_FUNCTIONReturn the free space in bytes of a given drive1Gerrit Mantel2000-01-012024-02-09010
fun_DriveProperty_TotalSizeSQL_SCALAR_FUNCTIONReturn the total size in bytes of a given drive1Gerrit Mantel2000-01-012024-02-09010
fun_DriveProperty_VolNameSQL_SCALAR_FUNCTIONReturn the volume name of a given drive (or remote share)1Gerrit Mantel2000-01-012024-02-09010
fun_FileExistSQL_SCALAR_FUNCTIONCheck if file exists1Gerrit Mantel2015-11-242026-01-23Recently modified010
fun_FileProperty_ArchivebitSQL_SCALAR_FUNCTIONReturn the archive bit of a file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_DateCreatedSQL_SCALAR_FUNCTIONReturn the date created of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_DateLastModifiedSQL_SCALAR_FUNCTIONReturn the date created of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_NameSQL_SCALAR_FUNCTIONReturn the name of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FileProperty_SizeSQL_SCALAR_FUNCTIONReturn the size (in bytes) of a given file1Gerrit Mantel2000-01-012024-02-09010
fun_FolderExistSQL_SCALAR_FUNCTIONCheck if folder exists1Gerrit Mantel2015-11-242026-01-23Recently modified010
fun_FolderProperty_DateCreatedSQL_SCALAR_FUNCTIONReturn the date created of a given directory name1Gerrit Mantel2000-01-012024-02-09010
fun_FolderProperty_DateLastModifiedSQL_SCALAR_FUNCTIONReturn the date last modified of a given directory name1Gerrit Mantel2000-01-012024-02-09010
fun_FolderProperty_NameSQL_SCALAR_FUNCTIONReturn the foldername of a given directory1Gerrit Mantel2000-01-012024-02-09010
fun_FolderProperty_SizeSQL_SCALAR_FUNCTIONReturn the size (in bytes) of a given directory1Gerrit Mantel2000-01-012024-02-09010
fun_int_arraySQL_TABLE_VALUED_FUNCTIONReturns a table with integer values between given minval and maxval1Gerrit Mantel2020-08-272024-02-09000
fun_nsplitSQL_TABLE_VALUED_FUNCTIONSplit delimited n-string into record values1Gerrit Mantel2005-03-212024-04-09000
fun_nsplit_notrimSQL_TABLE_VALUED_FUNCTIONSplit delimited n-string into record values1Gerrit Mantel2005-03-212024-04-09000
fun_splitSQL_TABLE_VALUED_FUNCTIONSplit delimited string into record values1Gerrit Mantel2005-03-212024-04-09000
fun_split_notrimSQL_TABLE_VALUED_FUNCTIONSplit delimited string into record values (not trimmed)1Gerrit Mantel2024-02-132024-04-09000
fun_time_arraySQL_TABLE_VALUED_FUNCTIONReturn time array for a given date with variable interval1Gerrit Mantel2015-12-022024-02-09000
fun_year2easterSQL_SCALAR_FUNCTIONReturn the date of 1-st easter day of a given year1Gerrit Mantel2004-12-072024-02-09000
prc_ps_computersystemSQL_STORED_PROCEDUREList properties of the local Computer System1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_diskSQL_STORED_PROCEDUREList properties of the Disks on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_diskpartitionSQL_STORED_PROCEDUREList properties of the Disk Partitions on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_dtcSQL_STORED_PROCEDUREList properties of the DTC on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_dtcnetworksettingSQL_STORED_PROCEDUREList properties of the DTC-Networksetting on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_networkadapterSQL_STORED_PROCEDUREList properties of the Networkadapter on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_networkadaptercfgSQL_STORED_PROCEDUREList properties of the Networkadapter Configuration on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_operatingsystemSQL_STORED_PROCEDUREList properties of the Operating System on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_processorSQL_STORED_PROCEDUREList properties of the Processor of the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_ps_volumeSQL_STORED_PROCEDUREList properties of the Volumes on the local computer1Gerrit Mantel2026-01-242026-01-24New104
prc_save_text_to_fileSQL_STORED_PROCEDUREWrite text variable to ansi file1Gerrit Mantel2017-01-252025-06-06010
prc_save_text_to_utf8fileSQL_STORED_PROCEDUREWrite text variable to utf-8 file with BOM1Gerrit Mantel2025-10-122025-10-12010
prc_table2csvSQL_STORED_PROCEDUREGenerate CSV file for a given table or view14.01Gerrit Mantel2026-01-182026-01-28Recently modified108
prc_table2htmlSQL_STORED_PROCEDUREGenerate HTML table for a given table or view14.01Gerrit Mantel2025-11-232026-01-29Recently modified005
prc_table2insertSQL_STORED_PROCEDUREGenerate insert commands for a given table or view14.01Gerrit Mantel2022-12-012026-01-28Recently modified002