Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 More intuitive GUI for T-SQL editing

Author  Topic 

dee-u
Starting Member

14 Posts

Posted - 2009-02-27 : 02:32:00
Is there a free GUI like that? I am looking for something that could automatically format my T-SQLs in SPs, hopefully intellisense, capitalized all keywords, etc...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-27 : 02:37:16
What about Microsoft SQL Server Management Studio?
You can download this tool for free with Express Edition.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-27 : 02:37:43
And then you install SSMSToolsPack add-in component.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2009-02-27 : 04:12:16
If you could extend yourself to cheap (but not free), you could have a look at some www.red-gate.com tools. they have sqlprompt (intellisense) and also a code formatting tool.
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-02-27 : 09:42:22
SQL Server 2008 has intellisense built in - it is also available in the free Express version:
http://www.microsoft.com/express/sql/default.aspx

Although it is not available when pointing at older versions of SQL Server.
Go to Top of Page
   

- Advertisement -