Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Building Joins the Easy Way Expand / Collapse
Author
Message
Posted Thursday, April 22, 2004 2:37 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dcorey/bu


All the best,

Dale

Author:
An Introduction to SQL Server 2005 Management Studio
Post #112657
Posted Monday, April 26, 2004 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 21, 2006 8:22 AM
Points: 2, Visits: 1

sheeeez, I've been using sqlserver for about 5 years now and didn't know all those options were on the menus!

 

tks

 




Post #113036
Posted Monday, April 26, 2004 3:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 16, 2006 5:15 PM
Points: 10, Visits: 1

Same like JimRyan, I've been using SQL server for 3-4 years but I didn't know that this facility was there. I used that facility in Access.

Thanks to Dale. Regards, Vincent

Post #113107
Posted Monday, April 26, 2004 5:58 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4

You folks are perfectly welcome!  Sorry about Figure 10.  I told Andy and Steve about it missing but I don't think they got to it before the article was published.  It's basically a print screen of the SELECT query as it appears in Query Analyzer.

Good luck to everyone who chooses to try query building with Enterprise Manager!

Sincerely,

Dale




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Post #113128
Posted Tuesday, April 27, 2004 3:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 2, 2006 3:10 AM
Points: 6, Visits: 1

Thanx Dale for your article and the information you threw light on. I was developing reports for my system which involved lot of big and complex sql scripts involving six to seven tables and i used to write the query which was really time consuming. Through this way i believe that it will really help me to save my time.

 

 

Post #113163
Posted Monday, October 4, 2004 12:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 4, 2004 12:08 PM
Points: 5, Visits: 1

Dale,

Thanks for taking the time to write a good article. I especially appreciate the screen shots.

A couple questions:

1) Where would you recommend a person go for assistance when the graphical tools are not sufficient?

2) What do you use for optimizations that are not provided in the graphical tools?

3) Why not use views for the type of problems you are presenting in your article. If the primary benefit from the graphical query painter is to provide join and filtering then this kind of work can be done effectively in a view once and used by all users who do not need to have effecient queries.

In short; it appears that your audience is for people to write SQL without knowing how to write SQL. A good DBA will have this already done for those who do not know how to write SQL through Views, User Defined Functions that return tables or Stored Procedures.

Still, I will be passing along your article to co-workers as it represents a lot of questions I answer frequently (sound like a contradiction) because I don't have enough time to do everything ahead of time.

Keep the tips coming.


Ben   

Post #139897
Posted Monday, October 4, 2004 1:21 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4

Benjamin,

I would recommend using templates and/or scripts (Object Browser) in Query Analyzer.

BTW, I have to write queries that involve many tables/joins.  I use QBE in Enterprise Manager to help me along with the most complex ones.  It really makes it a lot easier.  If you've never tried it, you should.  It's very cool.




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Post #139917
Posted Tuesday, November 16, 2004 8:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 27, 2006 12:41 PM
Points: 29, Visits: 1
One additional comment on this process.  I still find the query tools in EM awkward and wanted to make sure people know that you can follow the same process in this article, but using an Access Project to create views, procs and functions in SQL Server.  The interface is almost identical to the options in Access databases and has some features missing or awkward to use in EM.  Just a thought.


Post #146497
Posted Tuesday, December 14, 2004 9:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 15, 2006 10:18 AM
Points: 15, Visits: 1

Thanks for the article.  I too struggled with the options.  I even created an access project for the SQL database and continued to use Access as much as possible.  But It forced me to save every query before executing creating a mess of temp queries.

An even better option is to use the query generator in Visual Studio.  Create a Database Project and keep all your stored procedures and queries there (allows source contorl).  When you open the TSQL code file, you can highlight portions and right-click to build the Query visually.  This is a much better tool, but does not show the output as well as Query Analyzer.

VS2005 has even a better tool.

Dave C.

Post #150971
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse