Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Table variable in dynamic query RE: Table variable in dynamic query

  • July 3, 2015 at 2:28 am

    #1810141

    nidhi.naina (7/2/2015)

    BUt my lead somehow asked me to use table variable 🙁

    Ask him why, given the known performance problems that table variables often cause.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass