What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your patience.

    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.