Column names and comments

I still miss options for setings column names after SELECT statement.
Code like this

SELECT  staffId,
        staffName,
        grossSalary
FROM    personnel WITH &#40;ROWLOCK&#41;
WHERE   &#40;type IN &#40;'m', 'n'&#41;&#41;
        AND grossSalary &gt; &#40;@minSalary * 2&#41;

I would like to see like this:

SELECT  staffId, staffName, grossSalary
FROM    personnel WITH &#40;ROWLOCK&#41;
WHERE   &#40;type IN &#40;'m', 'n'&#41;&#41;
        AND grossSalary &gt; &#40;@minSalary * 2&#41;

I need column names in one line, because if SELECT clause contain a lot of names, script become difficult to read.

My Second wish is option for comments. I use a lot of comments in my code and now if I use 'Lay Out SQL' comment stay unchanged concerning other changed code.
Now, after Lay Out:

--my comment
         SELECT * FROM .................

I wish:

          --my comment
          SELECT * FROM ................

Regards
Uros

Urosd October 04, 2006 13:58

Comments

2 comments

Urosd wrote:
....
My Second wish is option for comments. I use a lot of comments in my code and now if I use 'Lay Out SQL' comment stay unchanged concerning other changed code.
Now, after Lay Out:
--my comment SELECT * FROM .................
I wish:
--my comment SELECT * FROM ................

Regards
Uros
Hi Uros,
Unfortunately in the first release we will not be able to handle comment placement. There are some technical reasons for this I would not like to go into on the forum. We will give it a go in future major versions of the product. Many thanks for the suggestion,

Andras
Andras B October 05, 2006 04:42

0
Urosd wrote:

I still miss options for setings column names after SELECT statement.
....
I need column names in one line, because if SELECT clause contain a lot of names, script become difficult to read.
....
Regards
Uros

We have looked at this option, and while we have inlcuded 4 new options since the CTP, this option did not make it (we now have 33 options). I have filed it, so we will consider your option in future releases.
I understand that there are many SQL styles, and while everyone needs only a single option ("my style "), there are quite a few of them. We do aim to add as many as we can.

Many thanks for your feedback,

Andras

Andras B October 05, 2006 04:49

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Column names and comments

Comments

Add comment