SQL Server Performance

What is a table variable and how can they be used?

Discussion in 'SQL Server 2008 General DBA Questions' started by Trev256, Apr 21, 2011.

  1. Trev256 New Member

    Does anyone have a good example of this please?
  2. FrankKalis Moderator

  3. mmarovic Active Member

    Actually, table variables were introduced in sql server 2000. :)
  4. FrankKalis Moderator

    Oops... [:)]
  5. Luis Martin Moderator

    In SQL 7.0. [:)]
  6. mmarovic Active Member

    Luis, are you sure?
  7. Luis Martin Moderator

  8. Luis Martin Moderator

    Sorry!!.
    My mistake. [:$]
  9. mmarovic Active Member

    No problem. I remember invstigating differences between temp tables and table variables, so I was afraid my memory started to fade too fast :)

Share This Page