ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

Hide SQL table

A simple easy way to hide tables in SQL Server

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...