Can you force SQLCMD to immediately run each statement in a script without using "GO"?

Question

When running a script in SQLCMD, is there a parameter, parameter, or any other way to get it to efficiently run the GO command at the end of each SQL statement?

This will prevent the need to embed periodic GO commands in very large scripts.

Answer 1

No.

SQLCMD would have to implement the full T-SQL parser itself to determine where the boundaries of the report are. If currently exists, all he needs to do is find the lines with "GO" on them.

, , ";" - .

Answer 2

, , , :

http://msdn.microsoft.com/en-us/library/ms162773.aspx

-c cmd_end . SQL Server, "GO" . reset , Transact-SQL, , .

....

; ; - ( , )

sqlcmd -c ;