| Author |
Topic |
|
benricho
Yak Posting Veteran
84 Posts |
 Posted - 2003-07-31 : 20:39:50
|
| Does everyone use Query Analyser to write there SQL statements or are there some really good tools out there I don't know about? Intellisense would be nice, SqlBuddy (http://sqlbuddy.sourceforge.net/) has intellisense but it still needs a bit of work from the quick look I had. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-31 : 20:43:45
|
| I think almost everyone uses QA. Intellisense is nice, it's convenient, but it's a great way to never fully learn a programming language, because with Intellisense you never HAVE TO learn. Look no further than every MS Access programmer, and anyone who uses Enterprise Manager; their SQL skills are usually poor. And I have yet to meet a Visual Interdev user who knows any HTML or JavaScript. |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-07-31 : 20:43:50
|
| well, just between us Aussies, I use Query Analyzer (but always with BOL cause I can never remember argument order).I also built my own little tool where you can paste in something likeTableAId, Name--------1, 'bill'2, 'fred'and it builds the SQL to create the table and insert the values. I've found that most people tend to explain problems by stating the data in that way...Specifically for my project, I've also built an SQL generation tool. What I'm doing though is very specific and so I have a lot of repeated patterns in SQL which wouldn't be easy with a generic SQL builder.....But that's just me - Cheers--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-08-01 : 11:41:03
|
quote:
Originally posted by rrbI've also built an SQL generation tool.
Code to write code....what's better?Cut and paste...I would venture to say these methods (and others) get more work done fatser, more effeciently and with less errors than EM Access, or any other "tools" you will find.And like Rob said you learn tons..Brett8-)SELECT POST=NewId() |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-08-01 : 12:57:56
|
quote:
-------------------------------------------------------------------------------- I think almost everyone uses QA. Intellisense is nice, it's convenient, but it's a great way to never fully learn a programming language, because with Intellisense you never HAVE TO learn. Look no further than every MS Access programmer, and anyone who uses Enterprise Manager; their SQL skills are usually poor. And I have yet to meet a Visual Interdev user who knows any HTML or JavaScript.
It's not the act of using these tools that makes you a bad programmer, it's the fact that it's possible (and pretty easy sometimes) to use this tools and BE a bad programmer. I'm proud to say i LOVE intellisens and I like Interdev. Guess what? I know HTML! and Javascript !! and those tools have done a lot to help me LEARN those languages. - Jeff |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-08-01 : 14:02:18
|
quote:
Originally posted by jsmith8858
quote:
-------------------------------------------------------------------------------- I think almost everyone uses QA. Intellisense is nice, it's convenient, but it's a great way to never fully learn a programming language, because with Intellisense you never HAVE TO learn. Look no further than every MS Access programmer, and anyone who uses Enterprise Manager; their SQL skills are usually poor. And I have yet to meet a Visual Interdev user who knows any HTML or JavaScript.
It's not the act of using these tools that makes you a bad programmer, it's the fact that it's possible (and pretty easy sometimes) to use this tools and BE a bad programmer. I'm proud to say i LOVE intellisens and I like Interdev. Guess what? I know HTML! and Javascript !! and those tools have done a lot to help me LEARN those languages.- Jeff
Hey Jeff, I'm with you. But then, I always knew I was the oddball when it came to using Interdev. Because I acually learned how to write HTML, I NEVER venture into the GUI side of Interdev because it's likely to really mess up my nicely formatted HTML code (don't even get me started on DTCs). So I used Interdev as a color-coded text editor with intellisense and a debugger.But as for the original question, I use QA because it's fast, convenient, free, color-coded, multi-windowed, and I already know SQL, and long-ago I learned how to touch-type. I have used an intellisense-type of editor for SQL commands (okay, really Oracle and it was TOAD). The hassle for me was that I had to keep typing the table name to get it to pop up a list of fields, and the delay was a pain, and yes I could multi-select, but then it made huge SQL commands with every field qualified by the full table name, which to me is a pain in the behind. If I need to qualify my fields, then I usually have an alias I use to make it easier. In SQL 2000's QA, you can display the list of databases/tables on the side for easy reference in case you don't remember what the field name was, but I'd venture to say that as you use it more, you get more familiar with the schema, and (hopefully) there is a consistent naming convention.Wow, how's that for lumping together a few pet peeves and tirades?  ------------------------------------------------------The more you know, the more you know you don't know. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-08-01 : 14:04:20
|
quote:
Because I acually learned how to write HTML, I NEVER venture into the GUI side of Interdev because it's likely to really mess up my nicely formatted HTML code .... So I used Interdev as a color-coded text editor with intellisense and a debugger.
I couldn't agree more !!!!  - Jeff |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-08-01 : 14:05:28
|
quote:
Originally posted by jsmith8858and those tools have done a lot to help me LEARN those languages.
Yes, as a starting point...Think though...when you believe somethinf (Access) is the be and end all..and the queries it generates...Gets pretty ugly....No?It's like all 4GL's...Brett8-)SELECT POST=NewId() |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2003-08-01 : 14:06:54
|
| I use .NET studio 2003 to write my SQL stuff. No intellisense there, but nice color coding and text editor features.Intellisense is a crutch for many people, imho.~ monkey |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-08-03 : 20:43:57
|
quote:
Intellisense is a crutch for many people, imho.
I'll take any crutch I can get if it helps me do my job faster, better, with less bugs and higher level of customer satisfaction - notice there's nothing in that list about helping me maintain my ego --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-08-03 : 21:28:31
|
| I'm definitely with you, rrb ...Being a good programmer has nothing to do with memorizing function arguments, spelling, methods, properties or even syntax.It's knowing how to write efficient (and correct!) algorithms, how to anticipate and write code that handles all situations (error checking!), and how to solve problems and get results as simply and straightfowardly as possible.- Jeff |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-08-03 : 21:30:02
|
| Oh no, you misunderstand. I was just saying that I'm a bad programmer!--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
Do you use Query Analyser or something else?