Tools › Mock data factory

T-SQL dummy data script (10,000+ rows)

You need a pile of rows and you are not allowed near production. This writes a tally CTE (or a WHILE) of boring, obvious fakes.

Rows Shape

Use a WHILE loop instead of a recursive CTE

Recursive CTEs cap at MAXRECURSION. We set it. Do not ask for a million years of days. Related: small INSERT builder, calendar CTE.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.