Collection of methods to generate random string in a single SQL statement

M1: Recursive string concatenation

On SQL Server the method is limited by 100 characters because of CTE recursion level limitation. The method has the performance issues when using in loops/joins because the table always have 100 rows generated every time.

9 unit tests, no integration tests...

Notepad++ can count LOC (lines of code) of source files and give you the estimation of code size.

Press Ctrl+Shift+F shortcut to start "Find in files" dialog. Select "regular expression" search mode and start it.

Some regular expressions:

How to set classic background color in Windows 10?

• Right click on desktop and select "Personalize" menu
• Set "Background" option to "Solid color"
• Click on "+ custom color" button
• Click on "More"
• Check that "RGB" is set
• Enter "#336EA5" and click "Done" button

That's all.

Delphi case

Delphi supports interfaces natively. Any variable of variant type can store an interface like any allowed data types.