Missing Semicolon

torsten.strauss

Hi Redgate Team,

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

Grant

Did that happen while typing or while formatting. I just tested it and it put the semicolons in the right spot during formatting.

torsten.strauss

Hi Grant.

During formatting.
I will send the version number tomorrow and hopefully some more details.

Thanks for looking into this.

Torsten

torsten.strauss

Hi Grant,

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

Grant

Interesting. I'm a little behind you on updates, 9.0.4, but it's working there. I'll get updated and see what happens.

torsten.strauss

Hi Grant!

Yes, you are right! I worked already in previous versions as I remember ...

Grant

Nuts. I can't replicate it. I'm still getting semi-colons. What version of SSMS or VS?

torsten.strauss

SSMS 14.0.17213.0

Grant

Well I'm at a loss. I'm on the same version of SSMS and it's working every time I try it.

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?

torsten.strauss

Hi Grant,

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

way0utwest

I loaded the script, and as you can see, it formats semicolons for me fine. I do see an issue with DBCC PAGE, but not semi colons. I don't have SSMS 14, but this does seem to work in ssms 17.4

torsten.strauss

Hi Grant.

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