Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Randy Dyess Temp table vs Table variable RE: Temp table vs Table variable

  • August 8, 2011 at 7:59 am

    #1365228

    GilaMonster (8/8/2011)

    Ninja's_RGR'us (8/8/2011)

    Not to be too anal here, but you can't really add NC indexes, you can only add NC constraints.

    And a unique constraint is enforced by a unique index, by default a nonclustered one. Other than splitting hairs was there a point?

    If the column that you want to have the index on is not unique, well, I had that in the example above...

    No that would be me missing something I had never thaught of on my own. I had never imagined going around the limitation of having to put a constraint by adding the PK in it. Very NICE! 😀

    Thanks again!