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 '14 at 13:01
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Tog, Indrek, Dave, Kevin Panko, Bob
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!