Search results 59

  2. Search results
  3. sql statement
Sorted from new to old.
Card image
Arabic in MySQL

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

2023Apr12
Card image
SQL Related posts

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

2022Jul6
Card image
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image
ANmaSQL_InsertStatement

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

2022Jul3
Card image
DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31
Card image
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23
Card image
TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19
Card image
NextID_Reset

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

2020Mar31
Card image
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24
Card image
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20
Card image
Reset ID Column

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

2020Feb9
Card image
Decode and NVL

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

2020Feb7
Card image
ANSQLWherein

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

2020Jan6
Card image
Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22
Card image
GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19
Card image
List of Databases

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

2019Oct6
1234