title: Create test data in SQL Server
body: <p>Does anyone have or know of a SQL script that will generate test data for a given table?</p>
  
  <p>Ideally it will look at the schema of the table and create row(s) with test data based on the datatype for each column.</p>
  
  <p>If this doesn't exist, would anyone else find it useful? If so I'll pull my finger out and write one.</p>