Search results 11

  2. Search results
  3. mssql
Card image cap
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19
Card image cap
Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12
Card image cap
Reset ID Column

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

2020Feb9
Card image cap
List of Databases

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

2019Oct6
Card image cap
LastInsertedID_SQL

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

2019Jul18
Card image cap
fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5
Card image cap
Shrinking DB

Steps to shrink database in MS SQL

2019Jan6
Card image cap
MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6
Card image cap
Arabic SQL+ASP

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

2018Sep24
Card image cap
RandomRecords

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

2018Jul29
Card image cap
MSSQL DB Connection

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

2018Jul29