As title, I chase the SQL

The following

With RelClass
As
(
Select * from AA_InventoryClass where id='DB3BE7AA - E5BB - 4013 - A34A - DCD4B4500E4C'
Union all
Select the CSC. * from AA_InventoryClass as CSC inner join RelClass as rc on CSC. Idparent=rc. Id)
SELECT * from RelClass
This is the query child node of

Under Windows 7 to run the program, then directly as the statement above

But under xp is running, in the above query in front with the exec, will prompt with nearby have a syntax error, how should do ah, very urgent!!!!!!!!!!

CodePudding user response:

SQL recursive calls is sql2005 increase function, query analyzer to perform in the operating system should be no problem.

Lz can use the above recursive query implementation, in the process of storage and Delphi data control call a stored procedure.

CodePudding user response:

Junction post bar, 100,
; With RelClass - add a semicolon before with
As
(
Select * from AA_InventoryClass where id='DB3BE7AA - E5BB - 4013 - A34A - DCD4B4500E4C'
Union all
Select the CSC. * from AA_InventoryClass as CSC inner join RelClass as rc on CSC. Idparent=rc. Id)
SELECT * from RelClass

CodePudding user response:

Met a similar problem, the result is has nothing to do with operating system version, related to database system version

CodePudding user response:

Too funny, knowing that is executed in XP add the error on the exec, also to ask, do seem very innocent appearance,