本文介绍了两种在SQL Server中检查Transact-SQL语句语法的方法：使用SET NOEXEC进行编译但不执行，以及使用SET PARSEONLY仅进行解析。SET NOEXEC适用于验证语法和对象名称，而SET PARSEONLY只解析语句。通过示例，展示了如何使用这两个选项来检查有效、无效的对象名和语法错误。
1.SET NOEXEC 方式 : 编译但不执行语句
When SET NOEXEC is ON, SQL Server compiles each batch of Transact-SQL statements but does not execute them. When SET NOEXEC is OFF, all batches are executed after compilation.
The execution of statements in SQL Server has two phases: compilation and execution. This setting is useful for having SQL Server validate the syntax and object names in Transact-SQL code when executing. It is also useful for debugging statements that would generally be part of a larger batch of statements.
The setting of
最低0.47元/天 解锁文章
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
