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.
Suppose that Office 2016 Pro Plus (MS ActionPack, MSDN subscription etc.) is installed on your PC but you still need to add some language support. In my case, I need to add the Russian proof tools to the English Office that includes already the French language support but doesn't contain any Cyrillic spell checking.