Internal query processor error: Query processor encountered an unexpected error during execution

The official explanation is as follows. I haven't figured out why. I didn't execute two identical select into statements as described below. I still reported this error, and after I changed it using the first method, I only passed the test for the first time, and this problem occurs later. Then I changed it to the second method and tested it several times. So far, no error has been reported. In addition, I use JDBC to execute SQL statements. I place the first and second SQL statements (original SQL statements) that are not used in the SQL server's built-in query analyzer for execution, is not reported this error, please give pointers to the http://support.microsoft.com/kb/323586/en-us

A select into query may return the following error message

MSG 8630, level 16, State 77, line XX internal query processor error: the query processor encountered an unexpected error during execution.

When all of the following conditions are true:

• You run the same select into query twice and separately.
• In between the two executions, you perform an operation that causes SQL Server to recompile the second select into query.

To work around this problem, add the option keep plan after the second select into statement, or change the current database to the target database before you run select into statements.

For example, you can add the keep plan option, or specify the target database before you run the select into statement:

Example:

Instead of using the following:

Select * into test2.. T2 from test1.. T1

Change it to either of the following:

Select * into test2.. T2 from test1.. T1 option (keep Plan)

-Or-

Use test2goselect * into test2.. T2 from test1.. T1