INSERT Auto-Completion layout feature

Michael.Kriegner

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

Anu D

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.

Michael.Kriegner

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 D

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.