SQL Server mock data generator: INSERT statements

You need ten rows to test a JOIN and you are not allowed near production. This builds INSERT statements with boring, obvious dummy values.

People search “generate mock SQL data” when they want a sandbox, not a leak. These values are fake: sequential ids, Name 1, 2026-01-01 plus a day, 10.00 times the row.

Guessed types: id → int, anything with date → date, amount/price/total → decimal, otherwise nvarchar. Edit the output if we guessed wrong.

WorkSQL already has a company you can query without inserts: Harbour & Co.