Hi, I observe that in some cases formatter changes the capitalisation of some names. Please see below three samples of these changes. Thank you for your help.
cases:
DECLARE @TopCount INT = 300
--changing variable name @TopCount to capitals in select top clause
SELECT TOP (@TOPCOUNT) JournalId = jr.JournalId
,CategoryId = jr.CategoryId
,AccountTransactionId = jr.AccountTransactionId
,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table jr
--changing variable @PeriodJournalDateList as table name to capitals in declare clause
DECLARE @PERIODJOURNALDATELIST TABLE (JournalDate DATE)
--changing cursor test_cur name to capitals
DECLARE TEST_CUR CURSOR FOR
OPEN test_cur INTO @aaa
DEALLOCATE test_cur
/*-----------------------------------------------
Expected behaviour:
DECLARE @TopCount INT = 300
--changing variable name @TopCount to capitals in select top clause
SELECT TOP (@TopCount) JournalId = jr.JournalId
,CategoryId = jr.CategoryId
,AccountTransactionId = jr.AccountTransactionId
,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table jr
--changing variable @PeriodJournalDateList as table name to capitals in declare clause
DECLARE @PeriodJournalDateList TABLE (JournalDate DATE)
--changing cursor test_cur name to capitals
DECLARE test_cur CURSOR FOR
OPEN test_cur INTO @aaa
DEALLOCATE test_cur
-----------------------------------------------*/
I fixed it in my test environment. Will need to do more tests tomorrow. For now it looks good and will probably publish it tomorrow 🙂
COOL, it's working! 👍