| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-05-29 : 18:14:02
|
| Hi, How do you get to query designer (the graphical representation)?Thanks,Sarat**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-29 : 18:28:29
|
| Right click on the table/view in EM and go to open table/view then go to query. Is that what you are looking for?BTW, I would not recommend using that tool. It creates really bad joins if you aren't careful.Tara |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-05-29 : 18:39:22
|
| Not really! One of the analyst is fond of MS Access so he was looking for a similar tool instead of QA to write sqls having table joins.except for the admins, no one has EM tool. I am not keen in giving EM to everyone since it takes up too much resources and definitely slower. Do all your developers have EM tool?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-29 : 18:58:40
|
| Yes all of the developers here have Enterprise Manager. They do not have any access to production (or QA and sanity environments), so the only harm that they can do is in their own development environment.Enterprise Manager is the only SQL Client Tool that comes with SQL Server that has the graphical query tool.You should encourage this analyst to learn T-SQL. He will write more efficient code if he learns the T-SQL way.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-29 : 23:40:25
|
| I agree with Tara, The developers shoud definitely learn T-SQL.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-30 : 00:02:14
|
quote:
Enterprise Manager is the only SQL Client Tool that comes with SQL Server that has the graphical query tool.
I agree that T-SQL is definitely the way to go but might your designer have access 2000 installed? If so he can set up an access adp and connect it to sql server then use the qbe. Again this should only be used as a learning tool you should really write your own SQL. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-30 : 10:53:01
|
quote:
Not really! One of the analyst is fond of MS Access so he was looking for a similar tool instead of QA to write sqls having table joins.
Firedquote:
except for the admins, no one has EM tool. I am not keen in giving EM to everyone since it takes up too much resources and definitely slower.
Slower than Access? Come on now...Ever do a Perf Mon on a Query based on a query based on a query based on a query...ad infinitum.Also do you kno whats happens when you link an Access form to sql serevr and you have say 5 drop down boxes based on code tables and som other bound colums? At least 6 connections (ie pig) and if any are updatable..double it. quote:
Do all your developers have EM tool?
Yes, I'm involved with them daily...(whats a set operation?)Sorry I just HATE Access...MOOPS Try doing a bunch of ands and ors in the same QBE grid in Access and see what you come up with...it's a simple example of disgusting (but in truth accurate) a query it generates...when you push it...look out.EDIT: I didn't use to hate access...I've writtem a couple of CRMs for mom and pop...but I've seen what's happens in an Enterprise enverionment...ahhhhhh  Brett8-)Edited by - x002548 on 05/30/2003 10:54:44 |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-30 : 21:16:54
|
| If you're going to use access as a front end make it an adp and use stored procedures, and disconnected recordsets so that you don't end up with a pig like X is talking about. |
|
|
|
|
Query Designer