What do you use for an SQL editor? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

General SQL Server Forums

New to SQL Server Programming

What do you use for an SQL editor?

Author

Topic

mokru
Starting Member

4 Posts

Posted - 2011-12-23 : 09:04:33

Just curious what people are actually using out there!

JK

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-12-23 : 09:06:19

I use SQL Server Management Studio.

The intellisense built into Management Studio is not the greatest. There are third party solutions - from RedGate and others. The one I use is SQLAssistant from Softtree.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-12-23 : 09:32:04

Management Studio with several RedGate plugins.

--
Gail Shaw
SQL Server MVP

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-23 : 09:46:42

dos

just kidding ssms

no really I use command shell a lot

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-23 : 09:47:19

that's because I'm old...ish

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-12-23 : 10:11:18

QA

KH
[spoiler]Time is always against us[/spoiler]

Sachin.Nand

2937 Posts

Posted - 2011-12-23 : 13:29:41

SSMS with ssmstoolpack.

PBUH

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-12-24 : 13:48:08

SSMS with ssmstoolpack also.

I turn ssms intellisense off because it is garbage.

Which is a real shame because when I'm doing c# dev in visual studio the intellisense is great!

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-24 : 14:57:46

SSMS here too...I too wont use Intellisense support

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-24 : 17:24:21

itella stupid

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Sachin.Nand

2937 Posts

Posted - 2011-12-26 : 23:30:22

quote:
Originally posted by visakh16

SSMS here too...I too wont use Intellisense support

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

I to hate that intellisense but I have this bad habit of forgetting the names of DMV's.So have to unwillingly keep it ON.

PBUH

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-26 : 23:38:25

SSMS with ssmstoolpack also.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-27 : 08:04:02

Mostly SSMS

Madhivanan

Failing to plan is Planning to fail

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2011-12-27 : 09:12:57

Just checked out ssmstoolpack. VERY awesome. I now use it along with SSMS.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-27 : 11:36:40

quote:
Originally posted by DonAtWork

Just checked out ssmstoolpack. VERY awesome. I now use it along with SSMS.

In case you weren't aware, it's made by SQLTeam's very own spirit1, Mladen.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2011-12-27 : 13:44:43

quote:
Originally posted by tkizer

In case you weren't aware, it's made by SQLTeam's very own spirit1, Mladen.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Yes, that is the FIRST thing i noticed when i hit the web site!

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources