是否可以让 SQLCMD 立即运行脚本中的每个语句而不使用“GO"? [英] Can you make SQLCMD immediately run each statement in a script without the use of "GO"?

问题描述

在 SQLCMD 中运行脚本时，是否有设置、参数或任何其他方式使其在每个 SQL 语句的末尾有效地运行 GO 命令?

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

这将防止需要将周期性 GO 命令插入到非常大的脚本中.

This would prevent the need to insert periodic GO commands into very large scripts.

推荐答案

没有

SQLCMD 必须自己实现一个完整的 T-SQL 解析器，以确定语句边界在哪里.鉴于它目前存在，它所要做的就是找到带有GO"的行.

SQLCMD would have to implement a full T-SQL parser itself in order to determine where the statement boundaries are. Whereas as it currently exists, all it has to do is find lines with "GO" on them.

确定语句边界可能非常棘手，因为;"对于大多数语句，终止符仍然是可选的.

Determining statement boundaries can be quite tricky, given that ";" terminators are still optional for most statements.

这篇关于是否可以让 SQLCMD 立即运行脚本中的每个语句而不使用“GO"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！