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

Related posts about sql-server

Related posts about tsql