I need a SQL Syntax Formatter for ASA online. Does exists specific for ASA? |
There are a couple of vim plugins that may be what you want: http://www.vim.org/scripts/script.php?script_id=356 and also script_id=1572 |
Hi You may want to try this one helpful: http://www.dpriver.com/pp/sqlformat.htm While they don't have special SQL Anywhere mode, SQL Server or Generic mode is pretty much sufficient in my experience. Hope it helps Leonid's suggestion is excellent! A truly easy-to-use interface, based on (apparently) some pretty powerful software. I threw what I thought was a deal-breaker at it, a funkadelic UPDATE from inside the Foxhound database monitor, and all it did was object to the ORDER BY in the LIST function. Apparently the desktop (for money?) version has an "ignore syntax errors" option. Anyway, here is the original code, followed by the output from dpdriver.com after the LIST ORDER BY was removed.. UPDATE rroad_group_2_property_pivot INNER JOIN ( SELECT temp_lock.blocked_connection_number, temp_lock.blocker_connection_number, temp_lock.blocker_owner_name, temp_lock.blocker_table_name, LIST ( STRING ( temp_lock.blocker_lock_class, ' ', temp_lock.blocker_lock_duration, ' ', temp_lock.blocker_lock_type ), ', ' ORDER BY temp_lock.blocker_lock_type ) AS blocker_reason, temp_lock.blocker_row_identifier FROM temp_lock GROUP BY temp_lock.blocked_connection_number, temp_lock.blocker_connection_number, temp_lock.blocker_owner_name, temp_lock.blocker_table_name, temp_lock.blocker_row_identifier ) AS temp_lock ON temp_lock.blocked_connection_number = rroad_group_2_property_pivot.connection_number AND temp_lock.blocker_connection_number = rroad_group_2_property_pivot.BlockedOn SET rroad_group_2_property_pivot.blocker_owner_name = temp_lock.blocker_owner_name, rroad_group_2_property_pivot.blocker_table_name = temp_lock.blocker_table_name, rroad_group_2_property_pivot.blocker_reason = temp_lock.blocker_reason, rroad_group_2_property_pivot.blocker_row_identifier = temp_lock.blocker_row_identifier WHERE rroad_group_2_property_pivot.sample_set_number = @sample_set_number; Formatted: UPDATE rroad_group_2_property_pivot INNER JOIN (SELECT temp_lock.blocked_connection_number, temp_lock.blocker_connection_number, temp_lock.blocker_owner_name, temp_lock.blocker_table_name, List(String(temp_lock.blocker_lock_class,' ',temp_lock.blocker_lock_duration, ' ',temp_lock.blocker_lock_type),', ') AS blocker_reason, temp_lock.blocker_row_identifier FROM temp_lock GROUP BY temp_lock.blocked_connection_number, temp_lock.blocker_connection_number, temp_lock.blocker_owner_name, temp_lock.blocker_table_name, temp_lock.blocker_row_identifier) AS temp_lock ON temp_lock.blocked_connection_number = rroad_group_2_property_pivot.connection_number AND temp_lock.blocker_connection_number = rroad_group_2_property_pivot.blockedon SET rroad_group_2_property_pivot.blocker_owner_name = temp_lock.blocker_owner_name, rroad_group_2_property_pivot.blocker_table_name = temp_lock.blocker_table_name, rroad_group_2_property_pivot.blocker_reason = temp_lock.blocker_reason, rroad_group_2_property_pivot.blocker_row_identifier = temp_lock.blocker_row_identifier WHERE rroad_group_2_property_pivot.sample_set_number = @sample_set_number; |
Actually, the above 2 do not format the SQL, but this Vim plugin does: SQLUtilities : SQL utilities - Formatting, generate - columns lists, procedures for databases http://www.vim.org/scripts/script.php?script_id=492 Dave |
You could also look at SQL Assistant. There is an old version available that is free. It come preconfigured to itergrate with a number of tools like Toad and ultraEdit( must be 15 on the list). The version I found was 3.5.1 and it said it was free but the about page is indicating it only has 14 days left on trail. Oh well it is something to look at. |
I use this from Werysoft, I found it after following a link on here to their query builder, I don't think it has a Sybase option but the generic SQL mode seems to work quite nice. Werysoft SQLFormatter |
Here is one more useful tool for SQL code formatting, which helps me to make my code more readable and beautifies SQL statements instantly and convert code into well formatted script. |