Format insert into

aGoramaGoram Posts: 18
edited October 5, 2009 8:53AM in SQL Prompt Previous Versions
v4 is really great, but one this is bugging me
i already said something about this, but it really frustate me :

in V3 :
INSERT INTO TABLE1 (
	COL1,
	COL2,
	COL3,
	COL4
) VALUES ( 
	/* COL1 - varchar(50) */ '',
	/* COL2 - varchar(250) */ '',
	/* COL3 - varchar(250) */ '',
	/* COL4 - char(1) */ ''
	)

in v4:
INSERT INTO TABLE1 (
	COL1,
	COL2,
	COL3,
	COL4
) VALUES ( 
	  ''
	, -- COL1 - varchar(50)
	  ''
	, --COL2 - varchar(250)
	  ''
	, --COL3 - varchar(250)
	  ''
	, --COL4 - char(1)
	)

In my opinion it is way more clear for this statement on v3.
i think there is no combination in the Formating option to get the same result as v3 ?

i just post this, to free my conscience....

Comments

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

    I have logged this as a faeture request (SP-2835) in our internal tracking system.

    So that this can be considered as a release candidate in future.

    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: support@red-gate.com
Sign In or Register to comment.