Hi, I notice that if i highlight a piece of T-SQL code to format the layout and the preceding piece of code on the page doesn't have a GO after it, like when I'm highlighting a CREATE PROCEDURE, Prompt will throw an error. e.g Create procedure needs to be the first command in the batch, which when I highlight it, it is however Prompt appears to read everything on the page. Is this by design or could it be fixed?
Comments
1 comment
-
By design. Promot tried to format as the parser would and without a batch separate, prompt can't determine if this is valid
It gets me, too, but I've learned to add go in between statements
Add comment
Please sign in to leave a comment.