Often while debugging the SQL code written another developer which is not formatted, formatting will help in analysing and debugging the code effectively. Also writting the SQL code with proper formatting improves the readability and is a best practise.
I found couple of online code formatting tools which formats SQL code very good and can be handy.
Tool 1: Instant SQL Formatter
Tool 2: SQLinForm
You may try the above tools next time when you need to format your SQL code.
Reference: DP (http://dptechnicalblog.blogspot.com/ )
I found couple of online code formatting tools which formats SQL code very good and can be handy.
Tool 1: Instant SQL Formatter
Tool 2: SQLinForm
You may try the above tools next time when you need to format your SQL code.
Reference: DP (http://dptechnicalblog.blogspot.com/ )
an sql formatter add-in for SSMS...http://www.dpriver.com/products/sqlpp/ssms_index.php
ReplyDelete