Missing Semicolon
torsten.strauss
Posts: 266 Silver 3
in SQL Prompt
Hi Redgate Team,
SQL Prompt is not adding semicolons:
Would be nice if you can fix this!
Thanks!
Torsten
SQL Prompt is not adding semicolons:
DROP TABLE IF EXISTS file_statistics_3; DROP TABLE IF EXISTS file_size_3 -- missing one DROP TABLE IF EXISTS waits_3 -- missing one GO
Would be nice if you can fix this!
Thanks!
Torsten
Tagged:
Answers
During formatting.
I will send the version number tomorrow and hopefully some more details.
Thanks for looking into this.
Torsten
Version is 9.0.6.3580 .
Even if I force SQL Prompt to add missing semicolons (CTRL B, (CTRL C) it does not work.
Torsten
Yes, you are right! I worked already in previous versions as I remember ...
Are there additional scripting elements before the example? I know that if there are scripts that contain errors it sometimes won't put semi-colons in. I also hit issues sometimes on giant scripts (I'm working on a couple of books and the scripts are enormous, sometimes formatting is pretty unhappy with me). Are these part of a multi-thousand line script?
it seems that there is something in the code itself which causes the issue.
I attached my script and you can see that SQL Prompt will raise an error in line 608 - 619 because of DBCC PAGE(BulkLogged, 1, 7, 3) WITH TABLERESULT if you format the entire script but if you highlight the Housekeeping section line 501-515 and just try to add the missing semicolons CTRL B + C nothing happens ...
It is bit wired
Torsten
I attached the script
Strange.
Can we have a quick call tomorrow?
I had a chat with redgate today and still can use the join.me session...
Thanks
Torsten