Anybody uses ULTRAEDIT ? Do you have the macro for formatting SQL code

Question

Anybody uses ULTRAEDIT ? Do you have the macro for formatting SQL code

mw_sql_developer

SSCoach

Points: 19445
More actions
January 13, 2012 at 12:58 pm

#99940

Team:
I need the macros for formatting sql code using ULTRAEDIT ?
Anybody uses ULTRAEDIT ? Do you have the macro for formatting SQL code

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

i played with making my own macro, but there are just so many variations/things to consider, you really need to do it in a programming language;

what's good for a SELECT statement formatting doesn't work for a CREATE TABLE statement, and a whole lot more.

I ended up buying a plug in for SSMS for $50 dollars instead, which works great for me. much less expensive than the Redgate version of a sql formatter.

thye've got a free trial version if you want to test drive it at SQL Pretty Printer for SSMS, which adds a new context menu called "SQL Beautifier"

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mw_sql_developer SSCoach Points: 19445 More actions · Answer 2

DO NOT REPLY TO THIS POST ANY MORE.. I am not interested in ULTREDIT.

I changed my mind.

This is the best SQL FORMATTING TOOL. TRY THIS ONLINE AND YOU WILL BE AMAZED!

All that you do is paste your sql press a button and you get the output formatted.

CAn be also installed to work with SSMS ( But you have to pay for that )

http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz

Great idea !

Lowell SSC Guru Points: 323518 More actions · Answer 3

glad I could help!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!