CODEWITHSUNDEEP
sql-serversql-server-2005indexing
birdie
birdie

Reputation:

How do i use a hashing computed column after i have indexed a varchar(max) field?

I created a computed column of type varbinary and referenced a varchar(max) field. Now, how do i use or invoke it?

thanks

Upvotes: 0

Views: 122

Answers (1)

gbn
gbn

Reputation: 432421

SELECT
    computedcolumn
FROM
    table

For indexing, look for "computed columns" in the CREATE INDEX statment. There are rules such as deterministic, and no longer than 900 bytes etc.

Is this what you wanted?

Upvotes: 1

Related Questions