Database 14 To deal with database and maintain it

Card image cap
Import error log

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

Card image cap
Arabic SQL+ASP

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

Card image cap
SQL Join

Different types of join in SQL. A good illustration image i found during my ...

Card image cap
RandomRecords

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

Card image cap
MSSQL DB Connection

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

Card image cap
MySQL DB connection

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

Card image cap
DB_SettingRead_Field

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

Card image cap
Modify SQL table

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

Card image cap
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

Card image cap
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

Card image cap
Connect to UDL

Use a UDL to make your connection to a database

Card image cap
DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...