Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Add 'N' to unicode type literal strings

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.

16 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Ogrish Man shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Andrei Rusitoru responded  · 

Hello,

We have added this feature in SQL Prompt 9.1.4.4532
It can be found under Prompt → Options → Style

It currently only works with variable assignments for variables declared in the same script.

If you would like to see us expand this more please let us know by creating a new idea.

Kind Regards,
The Prompt Team

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Thomas Franz commented  ·   ·  Report

    additional it would nice to have a Unicode / un-Unicode-function in this little Ctrl-Menu that adds / removes the 'N' in all strings in the selection.