Search results 59

Sorted from new to old.

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Mar4

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18

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

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Jan17

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

SQL Date from DateTime

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

2023Nov29

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

SqlExec

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

2023Sep3

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

Refresh Table from View

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

2023Jul19

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

DB Functions (By AI)

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

2023Apr23

1 2 3 4