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.
| Author |
Topic |
|
token
Posting Yak Master
133 Posts |
 Posted - 2005-11-13 : 20:22:23
|
| I am using SQL Server 2K developer edition. I am looking for a graphical way to make SQL querues. Does SQL Server come with such a toolset? I found something about Analysis Services in my SQL manual but I don't seem to have this feature. Do I need this feature to create SQL queries graphically?Cheers,token |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-11-14 : 03:17:02
|
| If you really must do that, it is possible in Enterprise Manager but it doesn't neccessarily produce the "best" code and there is an awful lot that you can't do graphically. I would recommend you learn SQL. When you have, you won't go back!steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
 |
|
|
token
Posting Yak Master
133 Posts |
Posted - 2005-11-14 : 09:45:47
|
| I have learnt SQL using Oracle, but its just too time consuming. How do I make SQL querues graphically in Enterprise Manager? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-14 : 09:56:03
|
| Dont rely on EMStart with these tutorialshttp://www.sql-tutorial.net/http://www.firstsql.com/tutor.htmMadhivananFailing to plan is Planning to fail |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-11-15 : 02:59:20
|
| Right click on Views and select New View but you are much better off writing it in SQL and if you have a problem there will be someone here who can helpsteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2005-11-25 : 12:58:19
|
| Thanks for that. I now use the View window to make most of my SQL queries. Its such a time saver! |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-11-28 : 03:24:48
|
| You really should use SQL. I don't know Oracle but the basics can't be that differentsteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
my_aro
Yak Posting Veteran
50 Posts |
Posted - 2005-11-28 : 06:08:45
|
| ow well.. oracle is perfectly same as with other sql, and definitely most of those keywords used in oracle are also with sql standards, i do teach oracle with college kids.. and i assume maybe if its just okay for you, you could try TOAD for oracle.. as far as i know TOAD is okay and i even use it for development, only for a fact that uses a bit of your time getting such tool for a reason that it always expires every 60 days, and a bit harder for questions(i mean support), and to tell you its for free.. |
|
|
|
|
|
|
GUI query maker