ID Number: Q78216
1.11
OS/2
buglist1.11
Summary:
Problem ID: PRSQL9111001
SYMPTOMS
Attempting to execute an INSERT statement containing a SELECT
statement that assigns values to a variable causes SQL Server to
GP-fault.
WORKAROUND
INSERT statements of this nature are in fact syntactically
incorrect. By definition, valid SELECT statements within INSERT
statements must return values. Since SELECT statements that assign
values to variables cannot be used to retrieve data, they are not
legal in INSERT statements. Therefore, this problem can be avoided
by not attempting to execute these types of INSERT statements.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version
1.11. We are researching this problem and will post new information
here as it becomes available.