```
SELECT 'INSERT INTO test ( name ) 
VALUES ( '''+S1.name+''' )' from SourceTable S1

```

while generating insert script as dynamic query, the unicode chararacter N is not getting prefixed even though the column is nvarchar. 

Insert without dynamic query worked well by prefixing N.