INSERT INTO #TempTable shows columns in strange order
TSchwab
Posts: 80
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!)
Please, help....
(My Version of SQL Prompt is 4.0.2.53 Professional Edition)
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!)
Please, help....
(My Version of SQL Prompt is 4.0.2.53 Professional Edition)
Regards,
Thorsten
Thorsten
Comments
I am sorry to hear you are having a problem with SQL Prompt. I have
reproduced the issue and logged it as a bug in our tracking system with
reference SP-2821. It will be reviewed for a future release of SQL
Prompt.
Kindly let me know if you have any other issues with SQL Prompt, I'll like to help.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
We have a good news for you
We have released a patch which includes the bug SP-2821 for SQL Prompt.
Kindly check this forum link and download the installer: http://www.red-gate.com/MessageBoard/vi ... php?t=9993
Please let us know if this build fixes the issue.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com