Is there any free/open source alternative of SQL Prompt? SSMS 2008 R2 intellisense is good but I need it for code optimization. For example it should notify me when there is an unused variable declared.
closed as off-topic by Tog, Indrek, Dave, Kevin Panko, Bob Apr 30 at 13:01
This question appears to be off-topic. The users who voted to close gave this specific reason:
You can try out the free SSMS and VS add-in, ApexSQL Complete
ApexSQL Complete provides snippets and syntax checking and a lot of code auto-complete features (context based predicting keywords, users, objects, autocompleting aliases, the Insert procedure parameters automatically option , the Insert full INSERT statement option and so on)
For code refactoring you could use ApexSQL Refactor, also a free add-in
Disclaimer: I work for ApexSQL as a Support Engineer
SQL Complete is pretty good.There's a full edition (About $100) and a free express edition!
protected by Community♦ Apr 29 at 10:27
Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.
Would you like to answer one of these unanswered questions instead?