Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Posts
    66

    Unanswered: syntax help -- clustered index

    what's wrong with this code?

    i'm trying to create a clustered index

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    I think you forgot to include the code...
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Jun 2006
    Posts
    66
    CREATE CLUSTERED INDEX statdate ON {statstest} ( column statsdatetime asc )

  4. #4
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    I think what you'ld like to do is:

    CREATE CLUSTERED INDEX statdate ON statstest (statsdatetime asc)
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Posting Permissions

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