Einzelnen Beitrag anzeigen

Benutzerbild von DP News-Robot
DP News-Robot

Registriert seit: 4. Jun 2010
14.967 Beiträge
 
#1

SQL: generate random character string

  Alt 26. Okt 2018, 11: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">
  Mit Zitat antworten Zitat