SQL: generate random character string

[DP News-Robot]

<div class="field field-name-body field-type-text-with-summary field-label-hidden view-mode-rss"><div class="field-items"><div class="field-item even">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 nested level limitation. The method has performance issue in loops/joins as a table with 100 rows is generated every time.


<div class="geshifilter">