SQL: generate random character string

Submitted by st on

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.

Install language pack on Office 2016 Pro Plus

Submitted by st on

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.

Pages

Subscribe to Mechanics of software RSS