semicolons

Hi

I was wondering if you can get SQL Assistant to auto add semicolons to the end of every batch statement in SQL Server?

This would be use for the thousand of lines of code that now need semicolons terminating each statement

Thanks

Hi,

I'm not sure there exist an algorithmic method for identifying "the end of every batch statement"
Only database programmers know where they want to terminate one batch and start another.

Hmmm, that's what I thought. Just testing my luck.
Oh well looks like many hours of Jnr. SQL resource time to be sold at some point.

Thanks

May have found a workaround. If you add a semi colon to the end of the statements in code formatting, then you can search-replace semicolons to the beginning of each statement in your procedure. This is easier to determine as each statement starts with a keyword. When you format the code the semi colon jumps the end of the previous statement. It is not perfect but it may get you most of the way there.

Hope this helps someone