INSERT INTO #TempTable shows columns in strange order

TSchwabTSchwab Posts: 80
edited November 18, 2009 8:52AM in SQL Prompt Previous Versions
Hi there,

when I type the following statements SQL-Prompt inserts the Columns in the INSERT INTO Statement not in the correct (given) order. :shock:

CREATE TABLE #Test (_OID INT PRIMARY KEY, Test NVARCHAR(MAX) , test2 NVARCHAR(MAX) , test4 NVARCHAR(MAX) , test3 NVARCHAR(MAX) )


INSERT INTO #Test
(Test
, [_OID]
, test2
, test3
, test4)
VALUES ( -- Test
-- _OID
-- test2
-- test3
-- test4
)
SELECT *
FROM dbo.Hello AS h

In 3.9 the order of the columns was the same as in the create statement.
(It works if a memory Temp-Table like @Test ... is used!) :cry:

Please, help....
(My Version of SQL Prompt is 4.0.2.53 Professional Edition)
Regards,

Thorsten

Comments

Sign In or Register to comment.