Random codes

Codes Required

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Feb8

ANmarAmdeen

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

Sep3

ANmarAmdeen

ANmaSQL_UpdateDateStatement

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

2022Jul4

ANmarAmdeen

ANmaSQL_InsertStatement

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

2022Jul3

ANmarAmdeen

ANSQLWherein

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

2020Jan6

ANmarAmdeen

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

ANmarAmdeen

DetectEmailServers

Detects mail servers available by returning number of available mail servers ...

2018Sep27

ANmarAmdeen

SQL Trigger

Trigger to convert value in table from comma separated into fields Used in ...

2018Jul15

ANmarAmdeen

ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

2018Jul11

ANmarAmdeen

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

ANmarAmdeen

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

ANmarAmdeen

Similar codes

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

ANmarAmdeen

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

ANmarAmdeen

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

ANmarAmdeen

Shrinking DB

Steps to shrink database in MS SQL

2019Jan6

ANmarAmdeen

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

ANmarAmdeen

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

ANmarAmdeen

NextID_Reset

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

2020Mar31

ANmarAmdeen

Connect to UDL

Use a UDL to make your connection to a database

2018May27

JeffSmith

Server Variables

This will list all server variables in a page.

2018Apr15

JeffSmith

Recently by developer

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Tue 7AM

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

ANmarAmdeen

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

ANmarAmdeen

BS3 Checks

Check boxes with Bootstrap colors From

2020Oct30

ANmarAmdeen

Arabic VS Hindi numbers

Settings to force Microsoft Word to show Hindi numbers with Arabic text, or ...

2019Jan14

ANmarAmdeen

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

ANmarAmdeen

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

ANmarAmdeen