Selecting a Function Value Shows nvarchar(4000) on an Index
Posted
by Jason N. Gaylord
on Stack Overflow
See other posts from Stack Overflow
or by Jason N. Gaylord
Published on 2010-06-02T18:25:44Z
Indexed on
2010/06/02
18:44 UTC
Read the original article
Hit count: 232
I have a view that I'm trying to setup an Index for. One of the select columns for the view executes a user-defined function that has a return value of varchar(250). However, when I try to setup an Index on that column, I see a size of nvarchar(4000). Why is that and will that cause a problem if I continue to setup my index?
© Stack Overflow or respective owner