Blogs

SQL: generate random character string

Submitted by Serguei_Tarassov 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 Serguei_Tarassov 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 RSS - blogs