SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

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 ...

DBTable2CSV

Exports table into CSV from ASP Classic function.

Hide SQL table

A simple easy way to hide tables in SQL Server

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 ...

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

ANSQLWherein

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