mardi 4 octobre 2016

TSQL: How to generate a random table of certain size in SQL Server?

Let say we need to write stored procedure that returns couple character fields and a number.

A - nvarchar
B - nvarchar
C - float

Is there a way to generate random table of predefined size in this stored procedure?

For example if size required is 5 than legit result ideally would be:

random string, random string 2, random number 1
random string 3, random string 4, random number 2
random string 5, random string 6, random number 3
random string 7, random string 8, random number 4
random string 9, random string 10, random number 5

Where random string would ideally satisfy some pattern.




Aucun commentaire:

Enregistrer un commentaire