Page 1 of 1
SQL Formatting : @@ROWCOUNT
Posted: Mon 12 Mar 2018 00:44
by 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?
Re: SQL Formatting : @@ROWCOUNT
Posted: Mon 12 Mar 2018 11:33
by 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.
Re: SQL Formatting : @@ROWCOUNT
Posted: Mon 12 Mar 2018 21:05
by 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.
Re: SQL Formatting : @@ROWCOUNT
Posted: Tue 13 Mar 2018 09:23
by alexa
That's right. There is no such a possibility in dbForge.