We help IT Professionals succeed at work.

Statement auto completion and formating for SQL Management Studio

zwseemm
zwseemm asked
on
I am using SQL Management Studio for creating views and stored procedures. Is there free program or add-in that I can use so it does smart formating similar to the way Visual Studio 2005 does. I am looking for something that will indent lines the right amount and do statement auto completion. I was a little surprised that SMS does not do it.
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
for your information, I also use the SQL prompt (from the link above), working quite nicely...

Author

Commented:
It looks like it is no longer a free download. Does that sound right to you two?
Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:
SQL Prompt is now from RedGate software and is no more free.

I use it everyday and it is worth every penny!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.