SQL Formatting : @@ROWCOUNT

[kevin.read]

dbForge SQL Complete 5.8.178

In the example SQL below, I would like the @@rowcount to be made UPPER case (@@ROWCOUNT).

Code: Select all

IF @@rowcount = 0
BEGIN
    PRINT '';
END;

Does anyone know the setting which controls this?

[alexa]

This can be setup as follows:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile and click the 'Edit Profile...' button. The 'Edit Formatting Profile' window opens.
4. Expand the 'Text Case -> Variable Case' node.
5. Select the 'Upper' option.

[kevin.read]

Thanks alexa. I have that setting set to "As in the declaration"

Code: Select all

DECLARE @Blah_Id INT;

IF @@ROWCOUNT = 0
BEGIN
    PRINT '';
END;

I want to retain the case of any user defined variables, but have system defined variable like @@ROWCOUNT as Upper.

I'm thinking that isn't possible currently.

[alexa]

That's right. There is no such a possibility in dbForge.