You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
A customer has reported a bug to us which was tracked down to the TSql150Parser. It appears that when parsing an an insert statement with an execute as the contents with execute options, the parser gives out errors.
This will parse correctly: INSERT INTO foo EXEC bar
as will this: EXEC bar WITH RECOMPILE
However the following will give errors: INSERT INTO foo EXEC bar WITH RECOMPILE INSERT INTO foo EXEC bar WITH RESULT SETS UNDEFINED INSERT INTO foo EXEC bar WITH RESULT SETS NONE
Based on the SQL Server documentation for INSERT and EXECUTE, the latter ones should be valid syntax.
The text was updated successfully, but these errors were encountered:
A customer has reported a bug to us which was tracked down to the TSql150Parser. It appears that when parsing an an insert statement with an execute as the contents with execute options, the parser gives out errors.
This will parse correctly:
INSERT INTO foo EXEC bar
as will this:
EXEC bar WITH RECOMPILE
However the following will give errors:
INSERT INTO foo EXEC bar WITH RECOMPILE
INSERT INTO foo EXEC bar WITH RESULT SETS UNDEFINED
INSERT INTO foo EXEC bar WITH RESULT SETS NONE
Based on the SQL Server documentation for INSERT and EXECUTE, the latter ones should be valid syntax.
The text was updated successfully, but these errors were encountered: