[feature request] Add 'N' to unicode type literal strings

ogrishman

Hi,

Is it possible to format below code

DECLARE @a VARCHAR(200);
SELECT  @a = 'asdf';
DECLARE @b NVARCHAR(200);
SELECT  @b = 'asdf';

to

DECLARE @a VARCHAR(200);
SELECT  @a = 'asdf';
DECLARE @b NVARCHAR(200);
SELECT  @b = N'asdf';

Thanks.

kondrich

Oh yes. This would be great!

Aaron L

Hi ogrishman,

This sounds like a cool idea!

We're using UserVoice to track feature requests like this as it helps us track the requests and lets other users vote on it (helping us prioritize which features to work on next).

It'd be great if you could add any requests to our UserVoice to increase their visibility.

Thanks,
Aaron.

KouryouChairudo@Work

This is a great feature. I love it. I tested it this morning but I have found an issue.

DECLARE @UnicodeText NVARCHAR(100) = 'une génération désenchantée'

will change to 

DECLARE @UnicodeText NVARCHAR(100) = 'une génération désenchantée'

So the inline assignment isn't changed.

Also doesn't work for insert and updates.