Option for actual results to be shown as INSERT statements
It would be great if there was an option to have the actual results in the SQL Test Messages window appear as INSERT statements so that I can just copy and paste them into my test case to populate the "expected" table.
I have a limited set of test data in my SetUp stored procedure, so I know the expected results are accurate. Right now I have to copy and paste each field's value into an appropriate insert statement in my test case, and this is very laborious. This could very easily be automated.
Marc Fearby commented
No doubt these messages simply come from tSQLt, but it wouldn't be too difficult to parse the text results (which are formatted in a predictable way) and turn them into INSERT statements.