I'm learning T-SQL. Why the strings are prefixed with N in every example I've seen?What are the pros or cons of using this prefix?Please make it clear that if my column has datatype as nvarchar /vachar then is it mandatory to provide values using 'N' as prefix or it just a system that we are following.
Sql Server string Prefix doubt
sql