如题,我追了下sql如下with RelClass
as
(
select * from AA_InventoryClass where id = 'DB3BE7AA-E5BB-4013-A34A-DCD4B4500E4C'
union all
select csc.* from AA_InventoryClass as csc inner join RelClass as rc on csc.idparent = rc.id )
SELECT * from RelClass
这个是查询子节点的 在win7 下运行程序后,就直接 如上边语句一样但是在xp下运行时,会在上边查询语句最前边加上exec,就会提示with附近有语法错误,该怎么办啊,非常急!!!!
as
(
select * from AA_InventoryClass where id = 'DB3BE7AA-E5BB-4013-A34A-DCD4B4500E4C'
union all
select csc.* from AA_InventoryClass as csc inner join RelClass as rc on csc.idparent = rc.id )
SELECT * from RelClass
这个是查询子节点的 在win7 下运行程序后,就直接 如上边语句一样但是在xp下运行时,会在上边查询语句最前边加上exec,就会提示with附近有语法错误,该怎么办啊,非常急!!!!
;with RelClass --with前加分号
as
(
select * from AA_InventoryClass where id = 'DB3BE7AA-E5BB-4013-A34A-DCD4B4500E4C'
union all
select csc.* from AA_InventoryClass as csc inner join RelClass as rc on csc.idparent = rc.id )
SELECT * from RelClass