Delphi-PRAXiS - SQL: generate random character string

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)

- Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)

- - SQL: generate random character string (https://www.delphipraxis.net/198352-sql-generate-random-character-string.html)

DP News-Robot

26. Okt 2018 11:30

SQL: generate random character string

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

Alle Zeitangaben in WEZ +1. Es ist jetzt 01:52 Uhr.