SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Formatting question

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Formatting question
Author Message
RobCrockett



Joined: 15 Aug 2008
Posts: 10
Country: United States

Post Formatting question Reply with quote
Our SQL style requires some items I am having trouble with.

We wrap the body of each stored proc in a begin/end pair and indent the body. I tried adding the begin and end to the formatting but the only way I could find to indent the body was to add a tab to each line of the formatting for each statement used in the proc. Is there a better way?

I am using SQL assistant 3.5 in SQL managements studio setup for SQL Server 2K.

Rob
Fri Aug 15, 2008 5:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
You will not be able to do that in version 3.5. There are no options available in the formatting area to indent non-specific SQL statement. formatting is applied to SQL statements not to stored procedures or other types of multi-SQL programs.

On other hand it is sooo easier to indent the entire SQL script/program, by simply highlighting the program text and pressing Tab.


There will be a greatly enhanced formatting facility available in version 4, but I don't know whether it will be possible to apply formatting to SQL programs rather then SQL statements.
Sun Aug 17, 2008 6:14 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.