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