I am previously user of of redgate SQL prompt when it is in beta stage and free. I really love auto complete in SQL Management Studio. This helps me so much when database tables are not created by me and field names are very hard to remember with under score("_"). This SQL prompt is essential productivity tool.
However, redgate SQL prompt stop beta stage and go for sales, I don't get the budget to buy the software. If you are like me long wishing for free alternative to redgate SQL prompt you can get now free by two ways.
First Approach, you can install free Microsoft SQL Server 2008 Management Studio Express. However, auto complete will only work with 2008 database only and will not work with current SQL 2005, 2000 databases. This is the sad limit though. Most of my company database are in SQL 2005 database server. So, this option is out for most of us.
Second Approach is to use this free tool PoorMansTSqlFormatter. It is work well with My SQL Management Studio 2005. Moreover, it has Format SQL option which will format messy SQL query to readable tab indented query statement. This is life saver features for me as I got many inline queries from my inherited old asp system. I copy from query form asp, paste in Management Studio and press Ctrl K+F and all ready for readability.
Cool, I love this tool.
No comments:
Post a Comment