为什么同样的命令在SQLCMD执行报错,在SSMS执行却没问题?
以下命令在SQLCMD执行报错如下,在SSMS中执行却没问题:
1> SELECT plan_handle, pvt.set_options, pvt.object_id, pvt.sql_handle
2> FROM (SELECT plan_handle, epa.attribute, epa.value
3> FROM sys.dm_exec_cached_plans
4> OUTER APPLY sys.dm_exec_plan_attributes(plan_handle) AS epa
5> WHERE cacheobjtype = 'Compiled Plan'
6> ) AS ecpa
7> PIVOT (MAX(ecpa.value) FOR ecpa.attribute
8> IN ("set_options", "object_id", "sql_handle")) AS pvt
9> go
消息 102,级别 15,状态 1,服务器 APPLE,第 8 行
'set_options' 附近有语法错误。
请问问题出在哪里?