INSERT Auto-Completion layout feature

Michael.KriegnerMichael.Kriegner Posts: 9
edited June 19, 2009 9:16AM in SQL Prompt Previous Versions
Perhaps you could consider a setting for layouting the insert statement.

I would write insert-statements like this:
INSERT TableX
(
    Column1,
    Column2
)
VALUES
(
    -- @Column1,
    -- @Column2
)

Kind regards,

Michael Kriegner

Comments

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

    We have our beta version of SQL Prompt 4.0 coming up for which we have early access build which can be downloaded from here.

    With SQL Prompt 4.0 insert-statement look like this:
    Insert Person.[Address]
            ( AddressLine1 ,
              AddressLine2 ,
              City ,
              StateProvinceID ,
              PostalCode ,
              rowguid ,
              ModifiedDate
            )
        VALUES
            ( NULL , -- AddressLine1 - nvarchar(120)
              NULL , -- AddressLine2 - nvarchar(120)
              NULL , -- City - nvarchar(60)
              0 , -- StateProvinceID - int
              NULL , -- PostalCode - nvarchar(30)
              NULL , -- rowguid - uniqueidentifier
              '2009-06-18 13:15:21'  -- ModifiedDate - datetime
            )
    

    Kindly let us know if that was fine with you else I can raise a feature request for the same.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • Thank you for your quick answer. I have seen your new solution in SQL Prompt 4.0. But, quite frankly I would prefer to configure it. It would be perfect, if it goes hand in hand with the layout functions/configuration.

    Thank you for your great support!

    Michael Kriegner
  • Anu DAnu D Posts: 876 Silver 3
    Thanks for update.

    I have added this as an feature request in our internal tracking system whose unique id is SP-2298. I have added a watch on this issue and will update you as soon as it is incorporated.

    Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.