SET instead of SELECT whenever possible
We use SQL Complete to format our SELECT statements. So the following
SELECT [aField] FROM [dbo].[aTable]
turns into
SELECT
[aField]
FROM
[dbo].[aTable]
However, this stament is then also transferred from
SELECT @intVariable = 1
into
SELECT
@intVariable =1
This is messy, so when we're not selecting from a table, we would like SQLComplete to format our that statement into
SET @intVariable = 1
In this case it all fits nicely on a single line again.
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your patience!
Just want to inform you that it is already fixed.
The settings are in the formatting profile.
So we would like to suggest updating to the latest version and check there.
Best,
Devart Support Team