Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2012-03-27 : 15:39:39
|
| Last time wasting question today:I use SQLAssistant and Redgate as addons to SSMS. I don't use them for much other than cleaning up the formatting of the code layout. Sometimes, it does the opposite. One of the things i dislike is with long INSERT INTO statements, it lists the field names vertically. I would prefer to see those field names clustered together in a paragraph sort of style. Is there any way to tweak SSMS to do so?thanksjames |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2012-03-27 : 16:03:52
|
| Brett,Not sure I follow how having leading commas is beneficial over trailing ones.--james |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2012-03-27 : 16:20:43
|
Which do you think is easy to "read"SELECT ThisIsMyColumn1, Col2, ArchiveDate, WWWW, [END], [BEGIN]FROM SELECT ThisIsMyColumn1 , Col2 , ArchiveDate , WWWW , [END] , [BEGIN]FROM I personally think the second one isBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/ |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-03-27 : 16:24:47
|
and with leading commas you can comment a line without having trouble...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-27 : 16:28:46
|
| Yuch. I like trailing commas. |
|
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2012-03-27 : 16:43:29
|
| proponents of leading commas: I see your point. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
Code formatting.