Microsoft KB Archive/101810
FIX: SELECT INTO Variable and Table May GP Fault Server
PSS ID Number: Q101810 Article last modified on 10-31-1994
|The information in this article applies to:|
|- Microsoft SQL Server versions 4.2 and 4.2a for OS/2|
BUG# OS/2: 1626 (4.2)
Executing a SELECT INTO statement that uses invalid syntax by assigning results to a local variable may trap SQL Server.
The following example traps the server:
declare @db_num smallint select @db_num = max(dbid) into #temp from sysdatabases
The above syntax is invalid. The same effect can be achieved by using either of the following two sets of statements:
declare @db_num smallint select @db_num = max(dbid) from sysdatabases
select max(dbid) into #temp from sysdatabases
If you want to assign to a variable and send data to a new table, use both statements.
Microsoft has confirmed this to be a problem in SQL Server versions 4.2 and 4.2a for OS/2. This problem was corrected in SQL Server version 4.2aK10. For more information, contact your primary support provider.
Additional reference words: 4.20 4.2 GP_Fault Transact-SQL KBCategory: kbprg KBSubCategory: SSrvServer
Copyright Microsoft Corporation 1994.