Random codes

Similar codes

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

ANmarAmdeen

Rolex Analog clock

Really good Rolex analog css+js illustration

2019Nov11

ANmarAmdeen

TrimEnters

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

2020Sep19

ANmarAmdeen

SQL Date from DateTime

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

Nov29

ANmarAmdeen

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

ANmarAmdeen

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

ANmarAmdeen

Shrinking DB

Steps to shrink database in MS SQL

2019Jan6

ANmarAmdeen

DB_AllRows

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

2018Apr23

ANmarAmdeen

Replace Single Quotes

This script will replace single quotes so the data is SQL-safe

2018Apr16

JeffSmith

Recently by developer

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Tue 8AM

ANmarAmdeen

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmarAmdeen

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

ANmarAmdeen

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

ANmarAmdeen

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

ANmarAmdeen

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

ANmarAmdeen

Treeview

CSS Tree, a treeview Originally from

2019Jan7

ANmarAmdeen

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

ANmarAmdeen