BRONZE PARTNER:
BRONZE PARTNER:
Industry News:
| |
| |
|
|
|
|
|
| Query Analyzer |
|
|
|
By: Garth Jones
Posted On: 7/16/2003
Query Analyzer
In a recent discussion about “Query Analyzer”, it was suggested that this would be a good topic for an article. I did some research in to the topic as I did not want to duplicate what has already been done. I decided to check out a few web sites to see what they had. I quickly realized that there is plenty of good information on the Internet about Query Analyzer and SQL. I will review a few of the web sites /articles that I found that are geared towards Query Analyzer / SQL.
SQL Server Central
This site is a sister site to My IT Forum. On this site I found a few articles, but before you can read any of the articles on this site you will need to create a User account.
The three following articles are a very good start for anyone who is looking for most information on Query Analyzer.
Getting the Most out of SQL Server 2000's Query Analyzer, Part I
http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp
This first article goes into:
- How to launch Query Analyzer
- Linked Servers
Getting the Most Out of SQL Server 2000's Query Analyzer, Part II
http://www.sqlservercentral.com/columnists/bkelley/qa2k_2_1.asp
The second article goes into detail on:
- The basic layout
- The cost
- Scripting existing objects
- Scripting new objects
- Using the transact-sql debugger
Getting the Most Out of SQL Server 2000's Query Analyzer, Part III
http://www.sqlservercentral.com/columnists/bkelley/qa2k_3_1.asp
This third article covers the following topics:
- Customizing the toolbar
- Editing shortcuts
- Adding custom tools
- Setting file options
- Configuring the editor
- Setting result output
- Defining connection settings
- Altering fonts and colors
- Selecting scripting options
There are other articles on this that might be of interest to the more advanced SQL users.
http://sqlcourse.com/
http://sqlcourse2.com/
These two web sites are really two articles or two complete interactive Online SQL training sessions. When I first saw these, I liked their setup.
The first site starts off with the basics. From a SMS perspective, here are some of the topics covered:
- Table Basic
- Selecting Data
- Deleting Record
- Deleting Tables
The second course is an advance course; it covers:
- Selecting Data
- Function (Min, Max, Count, etc.)
- Group by
- Having
- Order By
- Where
- Between
- Mathematical Operators ( =, >, <, etc)
- Joins
- Other Database Site Links
After reviewing all of these web sites / articles I found that each has a lot of good information to help you better understand Query Analyzer. By taking the time to go through each site, as this will help you understand Query Analyzer and become an expert SQL query writer.
|
|
|
|
|
|
