Post reply

"dictionary" based table

  • July 13, 2009 at 6:36 am

    #206849

    is there a way in sql server to define a table that it will be of type "dictionary" (where in dictionary i mean that the search of the text will be very fast like in a dictionary )

    thanks

    Peleg

  • July 13, 2009 at 6:56 am

    #1023839

    do you mean that you want to store text and search it or have a table where the contents are sorted? If it is the first then you need fulltext it it is the second you need a clustered index. Can you clarify what you want to do and what you want to store?

  • July 13, 2009 at 7:16 am

    #1023854

    i want to store text in a table with unique value of a column of type nvarchar(200)

    and to be able to search (fast ) for text...

    Thanks

    Peleg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply