17

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.

IsmailS
  • 719

2 Answers2

12

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

Milica Medic Kiralj
  • 401
5

SQL Complete is pretty good.There's a full edition (About $100) and a free express edition!

Ashildr
  • 2,770
  • 5
  • 28
  • 45
Lee
  • 51