Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    chennai
    Posts
    30

    Unanswered: using index.....

    hi all,

    As far i know,using index in an select query is allowed. Can we use index in an update query, if yes can anyone tell me the syntax how to use it?

    Thanks in advance,
    sekhar

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to books online for SELECT topic to use the index and in SQL 2k its used for backward compatability only.

    Also refer to this link for more information and tips.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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