INSERT Auto-Completion layout feature

Michael.Kriegner · June 17, 2009 6:50AM

Perhaps you could consider a setting for layouting the insert statement.

I would write insert-statements like this:

INSERT TableX
&#40;
    Column1,
    Column2
&#41;
VALUES
&#40;
    -- @Column1,
    -- @Column2
&#41;

Kind regards,

Michael Kriegner

Anu D · June 18, 2009 9:38AM

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.&#91;Address&#93;
        &#40; AddressLine1 ,
          AddressLine2 ,
          City ,
          StateProvinceID ,
          PostalCode ,
          rowguid ,
          ModifiedDate
        &#41;
    VALUES
        &#40; NULL , -- AddressLine1 - nvarchar&#40;120&#41;
          NULL , -- AddressLine2 - nvarchar&#40;120&#41;
          NULL , -- City - nvarchar&#40;60&#41;
          0 , -- StateProvinceID - int
          NULL , -- PostalCode - nvarchar&#40;30&#41;
          NULL , -- rowguid - uniqueidentifier
          '2009-06-18 13:15:21'  -- ModifiedDate - datetime
        &#41;

Kindly let us know if that was fine with you else I can raise a feature request for the same.

Michael.Kriegner · June 18, 2009 11:41AM

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 · June 19, 2009 9:16AM

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.

INSERT Auto-Completion layout feature

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk