Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote -1 down vote favorite
1

Between Notepad++ and TextPad and various sql development tools, I can't seem to find a single application that can assist with IF/THEN nesting or whatnot.

Is there a web application that can assist with this kind of thing?

I'm thinking something that can show if your if/then are out when your tab leveling, or something. It would be a great visual assistance tool for developers.

share|improve this question
dpriver.com/pp/sqlformat.htm is the best web based non-pay one I can find. – glasnt Aug 13 '10 at 3:40

closed as off topic by Eight Days of Malaise, Al Everett, ChrisF♦ Jan 10 at 13:44

Questions on Web Applications Stack Exchange are expected to relate to web applications within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

2 Answers

up vote 1 down vote

If you are talking about Transact SQL I would suggest looking at Redgate tools, specifically SQL Prompt as it will help some.

In general it is pretty poor coding practice to have IF/THEN loops statements that are nested very deep. In general I have never found a time when I use more than 2-3 IF/ELSE IF and then maybe 1 nested 1 inside. If you have more than that I would suggest looking at how to simplify your code.

Otherwise could you be more specific what SQL language are you using and what do you mean by IF/THEN nesting?

share|improve this answer
Technically it's If-begin-end; the standard for Sybase. I was just wondering if there was an app out where you could get some nice tab-intenting happening for specified conditions, like an autoformatter; but with added nesting notifications, e.g. coloured background, that one could then parse their code in a visual way to find issues with stray end clauses (which has been what I've banged my head against for the last week fretting over) – glasnt Jul 1 '10 at 15:18
Unfortunately, I don't know of any tools for Sybase. – RandomBen Jul 1 '10 at 15:28
up vote 2 down vote

This question was also asked on SO.

SQL Inform seems the best SQL one. Sorry I can't say I've used it though, I use Sql Redgate to layout my SQL.

share|improve this answer
A 100 line limit is limiting though, or you pay 30 euro, which I don't want to do. – glasnt Aug 13 '10 at 3:36

Not the answer you're looking for? Browse other questions tagged or ask your own question.