Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: Table data types in SQL Server 2000

    Hi,
    Can anybody give me some information on Table data types of SQL2K.
    How and where can it be used. Does it make the queries faster, in case there are many users using ?
    Please could anybody give me these details, to make me decide whether I can use it or not ?

    Thanx and Regards,
    Sushma

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You mean table variables, versus temporary tables?

    Table variables are generally faster, but temporary tables can be more extensively indexed. Both are fully appropriate (and often required) for multi-user environments.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •