How can we improve SQL Test?

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.

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Marc FearbyMarc Fearby shared this idea  ·   ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Marc FearbyMarc 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.

      Feedback and Knowledge Base