CREATE TABLE #nVarcharDemo
(C1 INT,
C2 NVARCHAR(10)
)
INSERT INTO #nVarcharDemo
-- Will Insert as "prhan" since you did't used "N"
SELECT 1, CONVERT(NVARCHAR,'prhān')
UNION ALL
-- Insert with 'N'
SELECT 2, CONVERT(NVARCHAR,N'prhān')
SELECT * FROM #nVarcharDemo
No one has followed this question yet.