sql server 2008 insert statement question
- by user61752
I am learning sql server 2008 t-sql.
To insert a varchar type, I just need to insert a string 'abc', but for nvarchar type, I need to add N in front (N'abc').
I have a table employee, it has 2 fields, firstname and lastname, they are both nvarchar(20).
insert into employee values('abc', 'def'); I test it, it works, seems like N is not required.
Why we need to add N in front for nvarchar type, what's the pro or con if we are not using it?
