SQL: generate random character string

Thema durchsuchen

Ansicht

Themen-Optionen

SQL: generate random character string

Ein Thema von DP News-Robot · begonnen am 26. Okt 2018

Antwort

DP News-Robot

Registriert seit: 4. Jun 2010
15.404 Beiträge

SQL: generate random character string

26. Okt 2018, 12:30

<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">