Search results 59

Sorted from new to old.

Install/Uninstall SQLNativeClient DB driver

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

Feb8

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

SqlExec

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

2023Sep3

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ANmaSQL_UpdateDateStatement

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

2022Jul4

ANmaSQL_InsertStatement

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

2022Jul3

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

1 2 3 4