Post reply

tSQLt and the INSERT EXEC Problem

  • February 7, 2016 at 10:40 pm

    #324634

    Comments posted to this topic are about the item tSQLt and the INSERT EXEC Problem

  • February 8, 2016 at 7:19 am

    #1857132

    Unfortunately you lost me here: "One of these was a procedure that created a prepared SQL query based on any combination of over 30 parameters. The procedure services at least 9 different applications and is executed more than 2 million times a day. "

    Having that many dependencies on a single stored procedure feels like bad practice to me.

  • February 8, 2016 at 7:44 am

    #1857138

    "Since the SQLCLR works by mapping data from the result set to the target table by column name, the order of the columns doesn’t matter, nor does the number. If the target table has more or less columns than the result set, that doesn’t matter either."

    Isn't this the fatal flaw in the process from a QA perspective? If the addition of new columns to a table are not detected, it seems to me that you have a major weakness in the testing process.

  • February 9, 2016 at 9:22 am

    #1857423

    Would a local loopback linked server be an easier solution for this?

  • February 9, 2016 at 9:37 am

    #1857435

    +1

  • March 8, 2016 at 4:33 pm

    #1863850

    Thanks for the article.

  • June 8, 2021 at 4:22 pm

    #3893507

    Good afternoon,

    I realize this article is a bit old at this point, but I found myself in need of a solution exactly like this.  Could you please post the full source code for this?  Thank you!

  • June 9, 2021 at 11:31 pm

    #3894135

    Message me on linked in

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply