Ships from: Edmonds, WA
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
With scalability for the most demanding applications, Microsoft® SQL Server™ 2000 can dramatically reduce the time needed to bring e-commerce, data warehousing, and line-of-business applications to market. Whether you’re new to databases or familiar with Microsoft Access, Oracle, and other relational databases, MICROSOFT SQL SERVER 2000 PROGRAMMING STEP BY STEP is the ideal way to learn how SQL Server can work for you. Written by an experienced database developer and author and replete with examples and exercises, this book will help you quickly get up to speed with creating and maintaining databases using the interactive tools provided by SQL Server 2000 Personal, Standard, and Enterprise Editions. It’s a must-have resource for anyone who wants to create and maintain databases and program with Transact-SQL.
This title shows you how to: Get started with SQL Server:
Included on CD-ROM!
Sample database files
Sample script code in Transact-SQL
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
In this lesson you’ll learn how to:
In the previous lessons, we’ve used the Enterprise Manager to create and maintain database objects and to perform basic data operations. In this lesson, we’ll look at another one of Microsoft SQL Server’s graphical tools—the Query Analyzer.
Understanding the Query Analyzer
Although it’s possible to create and execute queries and other Transact-SQL statements in the Enterprise Manager, its greatest strength is as a tool for database administration. The Query Analyzer, on the other hand, is primarily a programming tool.
The Query Analyzer provides you with powerful tools for writing and debugging complex sets of Transact-SQL statements in various forms. (We’ll look at one of these, SQL scripts, in this lesson.) It also provides the means to analyze the performance of queries via execution plans and the Index Tuning Wizard, as we’ll see in Lesson 23.
You can start the Query Analyzer from within the Enterprise Manager or from the Windows Start menu. When you start the Query Analyzer from the Enterprise Manager, the Query Analyzer will transfer the connection information from the Enterprise Manager: if you are connected to a server, the Query Analyzer will connect to that server, and if you have a database selected, the Query Analyzer will select that database.
If you start the Query Analyzer from the Start menu, or if you haven’t made a server or database connection in the Enterprise Manager, you must make the connection manually from within the Query Analyzer.
Start the Query Analyzer from the Enterprise Manager
SQL Server displays a list of database objects in the Details Pane.
(Image Unavailable)
SQL Server opens the Query Analyzer, automatically connecting to the server and the Aromatherapy database.
(Image Unavailable)
Start the Query Analyzer from the Start menu
The icons in the Microsoft SQL Server folder appear in a list.
Query Analyzer icon (Image Unavailable)
The Query Analyzer displays the Connect to SQL Server dialog box.
(Image Unavailable)
The Query Analyzer connects to the server, and then opens. The Query Analyzer will connect to whichever database has been selected as the default for your login.
(Image Unavailable)
The Query Analyzer will use the currently selected database to resolve references in queries and other Transact-SQL statements. Its toolbar, shown in Figure 21-1, contains a combo box showing the database that is currently selected. You can switch to a different database by selecting its name in the toolbar or from the Query menu.
Figure 21-1. The Query Analyzer toolbar displays the currently selected database. (Image unavailable)
Selecting a database using the toolbar
(Image Unavailable)
Select a database from the Query menu
The Query Analyzer displays the Select Database dialog box.
(Image Unavailable)
(Image Unavailable)
The Query Analyzer selects the Aromatherapy database.
The Query Analyzer initially displays two windows, the Object Browser and the Query window. When you first open the Query Analyzer, a single Query window is opened, but you can open a new window at any time by clicking the New Query button on the Query Analyzer toolbar.
New Query button (Image Unavailable)
The Query window displays the name of the database server, the current database, the current login, and the query name in the title bar. The Query window is similar to the Enterprise Manager’s Query Designer but is much more powerful.
As an editor, the Query window is more flexible and powerful than the Query Designer’s SQL Pane. While the Query Designer can process only a limited set of SQL statements, the Query window can process any valid Transact-SQL statement, and you can enter multiple statements for processing in a single batch.
Although the Query window doesn’t support the Grid or Diagram views available in the Query Designer, it supports additional views of a query that are used to analyze performance, as we’ll see in Lesson 23.
The Query window also gives you the option of displaying each view of the query in a separate tab, rather than as panes. This is often the most convenient way of viewing the query.
Entering Transact-SQL Statements
The simplest way to use the Query window is to type in an SQL statement, just as you would in the SQL Pane of the Query Designer. Unlike the Query Designer, however, the Query Analyzer’s Query window provides some extra assistance by color coding the Transact-SQL statements you enter. Table 21-1 shows the colors the Query window uses.
| Color | Meaning |
| Blue | Keyword |
| Dark Green | Comment |
| Dark Red | Stored Procedure |
| Gray | Operator |
| Green | System Table |
| Magenta | System Function |
| Red | Character String |
Table 21-1. Color coding used in the Query Analyzer’s Query window.
Execute a SELECT query
SELECT OilID, OilName, LEFT(LatinName, 10)
FROM Oils
(Image Unavailable)
Execute Query button (Image Unavailable)
The Query Analyzer adds a pane to the Query window containing two tabs: the Grids tab, which contains the query results, and the Messages tab.
(Image Unavailable)
The Query window displays the messages generated by the query.
(Image Unavailable)
Display query results in a separate tab
The Query Analyzer displays the Options dialog box.
(Image Unavailable)
(Image Unavailable)
(Image Unavailable)
The Query Analyzer changes the display of the Query window.
(Image Unavailable)
A script is a set of Transact-SQL statements stored in a file. Scripts are most often used to keep a permanent record of the commands used to create and populate database objects. Because the scripts are stored in text files, rather than in the database, they can be used to re-create the database on different servers. (SQL Server actually uses scripts to create the Pubs and Northwind sample databases.)
Although scripts are most often used for creating database objects, they’re not limited to this use. Any valid Transact-SQL statement can be included in a script.
The SQL statements in a script are grouped into batches. A script can contain one or more batches, and each batch can contain one or more SQL statements. In a script containing more than one batch, the batches are separated by the GO command. If a script doesn’t contain the GO command, all the statements will be executed as a single batch.
Create a script
SELECT OilID, OilName, LEFT(LatinName, 10)
FROM Oils
GO
SELECT PlantPartID, PlantPart
FROM PlantParts
The Query Analyzer displays the results in two panes of the Grids tab of the Query window.
(Image Unavailable)
Save button (Image unavailable)
The Query Analyzer displays the Save Query dialog box.
(Image Unavailable)
(Image Unavailable)
The Query Analyzer saves the new script file.
Open a script
New Query button (Image unavailable)
The Query Analyzer opens a new, empty Query window.
(Image Unavailable)
Open button (Image unavailable)
The Query Analyzer displays the Open Query File dialog box.
(Image Unavailable)
(Image Unavailable)
The Query Analyzer displays the script in the Query window.
(Image Unavailable)
Execute Query button (Image unavailable)
The Query Analyzer displays the results in the Grids tab.
(Image Unavailable)
The Object Browser is contained in the pane on the left side of the Query Analyzer window. Just as the Console Tree of the Enterprise Manager provides a hierarchical view of the objects in a SQL Server installation, the Objects tab of the Object Browser displays a hierarchical view of the databases in the server to which you’re connected, as well as other common objects used in creating Transact-SQL programs.
The Objects tab of the Object Browser is arranged somewhat differently from the Console Tree in the Enterprise Manager. Only database objects are listed, so items such as Logins and Data Transformation Services packages aren’t visible. Also, the tables in a database are divided into two folders for convenience: User Tables and System Tables.
Additionally, rather than simply listing the tables in a database the way the Enterprise Manager Console Tree does, the Object Browser displays the columns, indexes, constraints, and triggers that you’ve defined for the table, as well as the dependencies, the views, and the tables that depend on the table. Figure 21-2 shows the Object Browser display for the Oils table.
Figure 21-2. The Object Browser displays information about the tables in your database that’s useful from a programming perspective. (Image unavailable)
The Common Objects folder of the Object Browser contains, along with the built-in data types, a set of common Transact-SQL functions grouped into categories. For each function, the Parameters folder contains a description of each parameter, including its name and data types. Figure 213 shows the LEFT function as it is displayed in the Object Browser window.
(Image unavailable)
Figure 21-3. The Object Browser displays functions by categories in the Common Objects folder.
Using the Object Browser, you can open a table or view, similar to the way you display rows by opening the Query Designer in the Enterprise Manager. Having done so, you can simply view the rows, or you can insert new rows and edit existing ones.
You can also use the Object Browser when you’re creating Transact-SQL programs. You can add objects to the Query window using drag-and-drop, and you can create several different kinds of scripts automatically from the context menu.
When you right-click a table or view in the Object Browser and select Open, the Query Analyzer displays the rows in the table (or the results of the view’s SELECT statement) in the Open Table window.
Open a table
The Query Analyzer displays a list of tables in the database.
(Image Unavailable)
The Query Analyzer displays the rows in the table in an Open Table window.
(Image Unavailable)
Open a view
The Query Analyzer displays a list of all views in the database.
(Image Unavailable)
The Query Analyzer displays the rows returned by the query in an Open Table window.
(Image Unavailable)
Adding Objects to the Editor Pane
One of the simplest and most convenient capabilities of the Object Browser is its support for drag-and-drop. Whenever you need to specify an object listed in the Object Browser, simply drag it into position in the Editor Pane of the Query window, and its name will be pasted into the editor window.
Add a database object
Clear Window button (Image unavailable)
The Query Analyzer empties the Editor Pane.
SELECT *
FROM
(Image Unavailable)
The Query Analyzer pastes the table name into the statement.
(Image Unavailable)
Execute Query button (Image unavailable)
The Query Analyzer displays the results in the Grids Pane.
(Image Unavailable)
(Image Unavailable)
(Image Unavailable)
The Query Analyzer pastes all the column names into the statement.
(Image Unavailable)
Execute Query button (Image unavailable)
The Query Analyzer displays the results in the Grids pane.
(Image Unavailable)
Scripting is a more sophisticated version of the drag-and-drop functionality of the Object Browser. Scripting creates a complete Transact-SQL statement and is available from the context menus of most objects. Not all script types are applicable to all object types, and some types, such as function parameters or columns, have no scripting available at all.
The available scripts and the objects to which they apply are shown in Table 21-2. We’ll be looking at most of these scripts in the next lesson about creating and maintaining database objects.
| Script Command | Applicable Objects |
| Create | Table, Index, Constraint, Trigger, View, Stored Procedure |
| Alter | Trigger, View |
| Drop | Table, Index, Constraint, Trigger, View, Stored Procedure |
| Select | Table, View |
| Insert | Table, View |
| Update | Table, View |
| Delete | Table, View |
| Execute | Stored Procedure, Function |
Table 21-2. Scripting Options.
Scripts can be written to a new Query window, a script file, or the clipboard (where they can be pasted into an existing Query window). Some scripts, such as the function execution scripts, use replaceable parameters. The Query Analyzer provides a dialog box to make it easy to replace these parameters with the appropriate values.
Script a SELECT statement
The Query Analyzer opens a new Query window with the SELECT statement.
(Image Unavailable)
Execute Query button (Image unavailable)
The Query Analyzer displays the results in the Grids Pane.
(Image Unavailable)
Script a function
(Image Unavailable)
The Query Analyzer opens a new Query window with a SELECT statement, including the function.
(Image Unavailable)
The Query Analyzer opens the Replace Template Parameters dialog box.
(Image Unavailable)
(Image Unavailable)
The Query Analyzer replaces the parameters in the query.
(Image Unavailable)
Execute Query button (Image unavailable)
The Query Analyzer displays the results in the Grids Pane.
(Image Unavailable)
Lesson 21 Quick Reference
| To | Do this | Button |
| Start the Query Analyzer | Click the Start button on the task bar. Point to Programs and then to Microsoft SQL Server, and click Query Analyzer. | (Image Unavailable) |
| Select a database with which to work | Select the new database from the combo box on the Query Analyzer toolbar. | |
| Execute a Transact-SQL statement in the Query window | Type the statement in the Editor Pane, and click the Execute Query button on the Query Analyzer toolbar. | (Image Unavailable) |
| Create an SQL script | Enter the Transact-SQL statements in the Query window, and click the Save button on the Query Analyzer toolbar. | (Image Unavailable) |
| Load an SQL script | Click the Open button on the Query Analyzer, and select the script in the Open Script dialog box. | (Image Unavailable) |
| Open a table or view in the Object Browser | Right-click the table or view in the Object Browser, and select Open. | |
| Add an object to the Editor Pane from the Object Browser | Drag the object from the Object Browser, and drop it in the de- sired position in the Editor Pane. | |
| Script an object from the Object Browser | Right-click the object in the Object Browser, point to Script Object to <destination> As, and select the type of script desired. |
| Introduction | xvii | |
| Part 1 | Getting Started with SQL Server | |
| Lesson 1 | The SQL Server 2000 Environment | 3 |
| Understanding the Enterprise Manager | 4 | |
| Starting the Enterprise Manager | 5 | |
| Controlling SQL Server | 6 | |
| Registering a Server | 7 | |
| Starting and Stopping a Server | 12 | |
| The Enterprise Manager Console Tree | 13 | |
| The System Databases | 14 | |
| Connecting to and Exiting a Database | 16 | |
| Database Objects | 16 | |
| Exiting the Enterprise Manager | 17 | |
| Lesson 2 | Administering SQL Server | 19 |
| Backing Up and Restoring Databases | 20 | |
| Backing Up a Database | 20 | |
| Restoring a Database | 29 | |
| Using the Database Maintenance Plan Wizard | 30 | |
| Lesson 3 | SQL Server 2000 Security | 41 |
| Understanding Security Modes | 42 | |
| Windows Authentication | 42 | |
| SQL Server Authentication | 42 | |
| User Logins | 43 | |
| Creating User Logins | 43 | |
| Managing Logins | 56 | |
| Database-Level Security | 60 | |
| Database Users | 60 | |
| Database Roles | 63 | |
| Part 2 | Creating Databases | |
| Lesson 4 | Creating a Database | 77 |
| Creating Databases | 77 | |
| Creating a New Database | 78 | |
| Setting Database Properties | 85 | |
| Managing Databases | 88 | |
| Deleting a Database | 88 | |
| Lesson 5 | Creating Tables | 91 |
| Creating Tables | 92 | |
| Understanding Data Types | 93 | |
| Creating a New Table | 95 | |
| Adding Columns to a Table | 97 | |
| Managing Tables | 107 | |
| Altering Columns | 107 | |
| Altering Tables | 110 | |
| Lesson 6 | Creating Indexes | 115 |
| Understanding Indexes | 116 | |
| Creating Indexes | 116 | |
| Maintaining Indexes | 131 | |
| Altering Indexes | 131 | |
| Removing Indexes | 135 | |
| Lesson 7 | Creating Relationships | 139 |
| Understanding Relationships | 139 | |
| Creating Relationships | 142 | |
| Managing Relationships | 146 | |
| Altering Relationships | 146 | |
| Maintaining Relationships | 149 | |
| Lesson 8 | Creating Check Constraints | 157 |
| Understanding Check Constraints | 157 | |
| Creating Check Constraints | 158 | |
| Managing Check Constraints | 161 | |
| Altering Check Constraints | 161 | |
| Maintaining Check Constraints | 163 | |
| Lesson 9 | Creating Table Objects | 169 |
| Understanding Defaults | 170 | |
| Creating Defaults | 170 | |
| Understanding Rules | 176 | |
| Creating Rules | 176 | |
| Understanding User-Defined Data Types | 181 | |
| Creating User-Defined Data Types | 182 | |
| Lesson 10 | Creating Database Diagrams | 187 |
| Understanding Database Diagrams | 187 | |
| Creating a Database Diagram from an Existing Schema | 188 | |
| Using Database Diagrams to Maintain the Database | 196 | |
| Changing the Database Schema | 196 | |
| Creating Database Objects | 198 | |
| Part 3 | Retrieving Data | |
| Lesson 11 | Retrieving Rows | 207 |
| Using the Query Designer | 208 | |
| Viewing Rows in a Table | 208 | |
| Updating Rows in a Table | 210 | |
| Understanding the SQL Server Query Designer | 213 | |
| The Diagram Pane | 213 | |
| The Grid Pane | 214 | |
| The SQL Pane | 214 | |
| Lesson 12 | The SELECT Statement | 217 |
| Understanding the SELECT Statement | 218 | |
| Selecting All Columns | 218 | |
| Selecting a Subset of Columns | 220 | |
| Creating Column Aliases | 223 | |
| Creating Calculated Columns | 226 | |
| Using the TOP n Clause | 231 | |
| Lesson 13 | Sorting and Selecting Rows | 235 |
| The ORDER BY Clause | 236 | |
| Sorting Rows | 236 | |
| Sorting by Multiple Columns | 240 | |
| The WHERE Clause | 245 | |
| The Basic WHERE Clause | 245 | |
| Using Special Operators | 248 | |
| Combining Selection Criteria | 252 | |
| Lesson 14 | Joining Tables | 257 |
| Understanding the FROM Clause | 258 | |
| Creating Joins | 259 | |
| Inner Joins | 260 | |
| Outer Joins | 269 | |
| Unions | 277 | |
| Lesson 15 | Summarizing Data | 281 |
| Understanding SELECT DISTINCT | 282 | |
| Using SELECT DISTINCT | 282 | |
| Understanding GROUP BY | 289 | |
| Using GROUP BY | 289 | |
| Using the HAVING Clause | 293 | |
| Lesson 16 | Views | 299 |
| Understanding Views | 299 | |
| Creating Views | 300 | |
| Using Views | 310 | |
| Managing Views | 317 | |
| Altering Views | 317 | |
| Removing Views | 320 | |
| Part 4 | Working with Data | |
| Lesson 17 | Adding Rows | 325 |
| Understanding the INSERT Statement | 326 | |
| Using the INSERT statement | 326 | |
| Inserting Rows Using the Grid Pane | 326 | |
| Inserting Rows Using the SQL Pane | 330 | |
| Inserting Multiple Rows | 335 | |
| Lesson 18 | Updating Rows | 345 |
| Understanding the UPDATE Statement | 345 | |
| Using the UPDATE Statement | 346 | |
| Updating Rows Using the Grid Pane | 346 | |
| Updating Rows Using the SQL Pane | 352 | |
| Updating Rows Using the FROM Clause | 355 | |
| Lesson 19 | Deleting Rows | 359 |
| Understanding the DELETE Statement | 360 | |
| Using the DELETE Statement | 361 | |
| Deleting Rows Using the Grid and Diagram Panes | 361 | |
| Deleting Rows Using the SQL Pane | 365 | |
| Using the TRUNCATE TABLE Statement | 372 | |
| Deleting All Rows Using the TRUNCATE TABLE Statement | 373 | |
| Lesson 20 | Copying and Moving Data | 377 |
| The Data Transformation Services Wizards | 377 | |
| Using the DTS Import Wizard | 378 | |
| Using the DTS Export Wizard | 388 | |
| Attaching and Detaching Databases | 396 | |
| Detaching a Database | 396 | |
| Attaching a Database | 397 | |
| The Copy Database Wizard | 399 | |
| Using the Copy Database Wizard | 399 | |
| Part 5 | Transact-SQL | |
| Lesson 21 | The Query Analyzer | 409 |
| Understanding the Query Analyzer | 410 | |
| Starting the Query Analyzer | 410 | |
| Selecting a Database | 413 | |
| Using the Query Window | 415 | |
| Entering Transact-SQL Statements | 416 | |
| Using SQL Scripts | 420 | |
| Using the Object Browser | 425 | |
| Opening Objects | 427 | |
| Adding Objects to the Editor Pane | 430 | |
| Scripting Objects | 434 | |
| Lesson 22 | Data Definition Language | 441 |
| Understanding DDL | 441 | |
| Creating Objects | 442 | |
| Altering Objects | 451 | |
| Dropping Objects | 459 | |
| Using the Object Browser for Data Definition | 463 | |
| Scripting DDL | 463 | |
| Using Templates | 465 | |
| Lesson 23 | Analyzing Queries | 471 |
| Using the Query Analyzer to Optimize Performance | 472 | |
| Execution Plans | 472 | |
| Server Traces | 479 | |
| Client Statistics | 480 | |
| The Index Tuning Wizard | 482 | |
| Using the Index Tuning Wizard | 482 | |
| Lesson 24 | Transact-SQL Language Components | 491 |
| Transact-SQL Commands | 492 | |
| Data Manipulation Commands | 494 | |
| Data Definition Commands | 494 | |
| Database Administration Commands | 495 | |
| Other Commands | 496 | |
| Transact-SQL Operators | 496 | |
| Operator Precedence | 496 | |
| Comment Operators | 497 | |
| Arithmetic Operators | 498 | |
| Comparison Operators | 501 | |
| Logical Operators | 503 | |
| Bitwise Operators | 505 | |
| Other Operators | 507 | |
| Transact-SQL Functions | 509 | |
| Using Functions | 510 | |
| Date and Time Functions | 510 | |
| Mathematical Functions | 513 | |
| Aggregate Functions | 516 | |
| Metadata Functions | 519 | |
| Security Functions | 521 | |
| String Functions | 523 | |
| System Functions | 526 | |
| Lesson 25 | Programming Objects | 529 |
| Temporary Tables | 530 | |
| Understanding Temporary Tables | 530 | |
| Using Temporary Tables | 531 | |
| Variables | 542 | |
| Understanding Variables | 542 | |
| Using Variables | 546 | |
| Lesson 26 | Controlling Execution | 553 |
| Conditional Processing | 554 | |
| IF...ELSE | 554 | |
| CASE | 557 | |
| The GOTO Command | 562 | |
| Looping | 564 | |
| Simple WHILE loop | 564 | |
| Complex WHILE Loops | 566 | |
| Lesson 27 | Transact-SQL Cursors | 571 |
| Understanding Cursors | 572 | |
| Cursor Characteristics | 573 | |
| Cursor Types | 574 | |
| Using Cursors | 576 | |
| Creating Cursors | 576 | |
| Manipulating Rows with a Cursor | 580 | |
| Updating and Deleting Rows with a Cursor | 590 | |
| Monitoring Transact-SQL Cursors | 592 | |
| Lesson 28 | Stored Procedures | 597 |
| Understanding Stored Procedures | 598 | |
| Exchanging Data with Stored Procedures | 598 | |
| System Procedures | 599 | |
| User-Defined Stored Procedures | 600 | |
| Using and Creating Stored Procedures | 600 | |
| Using Stored Procedures | 600 | |
| Creating Stored Procedures | 609 | |
| Lesson 29 | Triggers | 623 |
| Understanding Triggers | 623 | |
| AFTER Triggers | 624 | |
| INSTEAD OF Triggers | 625 | |
| Creating Triggers | 626 | |
| Using the CREATE TRIGGER Command | 626 | |
| Using the UPDATE Function | 632 | |
| Using the Inserted and Deleted Tables | 634 | |
| Lesson 30 | User-Defined Functions | 639 |
| Understanding User-Defined Functions | 639 | |
| Scalar Functions | 640 | |
| Table-Valued Functions | 640 | |
| Creating User-Defined Functions | 641 | |
| Creating Scalar Functions | 642 | |
| Creating Table-Valued Functions | 644 | |
| Using User-Defined Functions | 648 | |
| Using User-Defined Functions in Transact-SQL Statements | 649 | |
| Using User-Defined Functions in Table Definitions | 652 | |
| Glossary | 659 | |
| Index | 665 |
Anonymous
Posted Tue Feb 01 00:00:00 EST 2005
I am fairly new to SQL 2000 and thought this book would help. If you like just doing the steps without an explanation of what your doing or why then this is the book for you. Some of the steps leave you hanging as to where you go. The pictures in the book do not always look like the one you see in front of you in SQL and the entries do not always work. Lesson 17 is a real pain to get through without trying to figure out what was left out of the step to get the query to run. As I said if you just want to copy examples and not really understand why your entering the info go for it but it is not worth the almost $50.00 for the book. If I had not opened the cd that comes with the book I would be returning it for my money.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Wed Dec 03 00:00:00 EST 2003
This book is nothing more than a collection of screen shots with no explanation of the underlying concepts being presented.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Wed Feb 26 00:00:00 EST 2003
I would agree with the above mentioned review. This book is simply a 'cookbook' and their is no mention as to WHY you do something. I would NOT recommend this book nor the author for someone who wants to learn SQL 2000.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Tue Nov 20 00:00:00 EST 2001
This is one of the worst Step by Step books I've bought. It is full of 'filler' pages designed to bulk up the book. It still moves through instructions to open a table in design view or return all rows view after 20 chapters. In addition, there are NO explanations of WHY you are doing something. The author just tells you to type commands in the SQL view screen but never tells you why the command did what it did. I have had great success with other Step by Step books by different authors but I would advise to stay away from this one!!
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
With scalability for the most demanding applications, Microsoft® SQL Server™ 2000 can dramatically reduce the time needed to bring e-commerce, data warehousing, and line-of-business applications to market. Whether you’re new to databases or familiar with Microsoft Access, Oracle, and other relational databases, MICROSOFT SQL SERVER 2000 PROGRAMMING STEP BY STEP is the ideal way to learn how SQL Server can work for you. Written by an experienced database developer and author and replete with examples and ...