Database 70

To deal with database and maintain it

Sorted from new to old.

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

2019Sep9

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

LastInsertedID_SQL

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

2019Jul18

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29

Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

2018Sep24

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

MySQL DB connection

Connects to MySQL database from Classic ASP All DB variables need to be ...

2018Jul29

DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

1 2 3 4 5