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

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

ANmarAmdeen

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

Jul22

ANmarAmdeen

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

ANmarAmdeen

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

ANmarAmdeen