Wiley.com
Print this page Share

Mastering Microsoft SQL Server 2005

ISBN: 978-0-7821-4380-5
1056 pages
March 2006
Mastering Microsoft SQL Server 2005 (0782143806) cover image

Description

The Comprehensive Resource for SQL Server 2005 Administrators, Consultants, and Developers

Whether you're a systems administrator, database application developer, or IT consultant, you'll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005's enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.

Coverage Includes

  • Integrating SQL Server with .NET Framework
  • Understanding Service Broker, a distributed application framework
  • Programming with ADO.NET, the data-access component of .NET
  • Setting up Notification Services, which delivers personalized information to mobile devices
  • Using SQL Server Management Studio instead of Enterprise Manager
  • Designing made easier with new Business Intelligence Development Studio (BIDS)
  • Printing multi-page reports
  • Mastering Transact-SQL programming language

Leverage the Experience of Large-Scale Enterprises through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshooting

Discover What SQL Server 2005's Increased Emphasis on Connectivity Means to Your Installation

Start Developing Apps--All the Information You Need!

www.sybex.com

See More

Table of Contents

Introduction.

Part 1: Introducing SQL Server.

Chapter 1: Introduction to SQL Server 2005.

Chapter 2: Overview of Database Concepts.

Chapter 3: Overview of SQL Server.

Chapter 4: Database Design and Normalization.

Part 2: Transact-SQL.

Chapter 5: Transact-SQL Overview and Basics.

Chapter 6: SELECT Queries.

Chapter 7: Action Queries.

Chapter 8: Topics in Advanced Transact-SQL.

Part 3: Digging into SQL Server.

Chapter 9: Using SQL Server Management Studio.

Chapter 10: Databases.

Chapter 11: Tables.

Chapter 12: Indexing.

Chapter 13: Views.

Chapter 14: Stored Procedures.

Chapter 15: Using Triggers.

.Part 4: Administering SQL Server.

Chapter 16: Basic Administrative Tasks.

Chapter 17: Automating Administration.

Chapter 18: Security and SQL Server 2005.

Part 5: Development with SQL Server.

Chapter 19: Integrating SQL Server with Microsoft .NET.

Chapter 20: ADO.NET and SQL Server.

Chapter 21: SMO and RMO Programming.

Chapter 22: Integration Services.

Part 6: Advanced Topics.

Chapter 23: Locking.

Chapter 24: Monitoring and Optimizing SQL Server 2005.

Chapter 25: Replication.

Chapter 26: Analysis Services.

Chapter 27: Notification Services.

Chapter 28: Reporting Services.

Chapter 29: Service Broker.

Chapter 30: Troubleshooting.

Appendix A: Transact-SQL Reference.

Index.

See More

Author Information

Mike Gunderloy is one of the world's foremost database developers. He has written Mastering SQL Server 2000, Visual Basic Developer's Guide to ADO, and SQL Server In Record Time and contributed to Access Developer's Handbook (in several versions), all from Sybex.

Joseph L. Jorden is the co-author of Mastering SQL Server 2000 and has served as the technical editor for several Sybex books.

David W. Tschanz has worked on a variety of pro-jects related to Web-accessible information and also serves as a computer security liaison.

See More

Errata

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
6 148 Mislabeled Table on Pg. 148

Chapter 6, page 148, has a mislabeled table: "HumanResources.Employee.DepartmentID" should be changed to "HumanResources.Employee.Employee ID"

3-26-2007
395 Procedure Correction
It appears that the method described was modified in the Production Edition and the Stored Procedure Assisted Editor is not part of the final released edition.  The actual procedure should be as described:
 

  1. In Object Explorer, connect to an instance of SQL Server 2005 Database Engine and then expand that instance.
  2. Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.
  3. Right-click Stored Procedures, and then click New Stored Procedure.
  4. On the Query menu, click Specify Values for Template Parameters.
  5. In the Specify Values for Template Parameters dialog box, the Value column contains suggested values for the parameters. Accept the values or replace them with new values, and then click OK.
  6. In the query editor, replace the SELECT statement with the statements for your procedure.
  7. To test the syntax, on the Query menu, click Parse.
  8. To create the stored procedure, on the Query menu, click Execute.
  9. To save the script, on the File menu, click Save. Accept the file name or replace it with a new name, and then click Save.

EXAMPLE:

  1. In Object Explorer, connect to an instance of SQL Server 2005 Database Engine and then expand that instance.
  2. Expand Databases, expand the AdventureWorks database, and then expand Programmability.
  3. Right-click Stored Procedures, and then click New Stored Procedure.
  4. On the Query menu, click Specify Values for Template Parameters.
  5. In the Specify Values for Template Parameters dialog box, enter the following values for the parameters shown.

  6. Parameter Value
    Author Your name
    Create Date Today's date
    Description Returns employee data.
    Procedure_name HumanResources.uspGetEmployees
    @Param1 @LastName
    @Datatype_For_Param1 nvarchar(50)
    Default_Value_For_Param1 NULL
    @Param2 @FirstName
    @Datatype_For_Param2 nvarchar(50)
    Default_Value_For_Param2 NULL

  7. Click OK.
  8. In the query editor, replace the SELECT statement with the following statement:

  9. SELECT FirstName, LastName, JobTitle, Department
    FROM HumanResources.vEmployeeDepartment
    WHERE FirstName = @FirstName AND LastName = @LastName;

  10. To test the syntax, on the Query menu, click Parse. If an error message is returned, compare the statements with the information above and correct as needed.
  11. To create the stored procedure, on the Query menu, click Execute.
  12. To save the script, on the File menu, click Save. Enter a new file name, and then click Save.
  13. To run the stored procedure, on the toolbar, click New Query.
  14. In the query window, enter the following statements:

  15. USE AdventureWorks;
    GO
    EXECUTE HumanResources.uspGetEmployees @FirstName = N'Diane', @LastName = N'Margheim';
    GO

  16. On the Query menu, click Execute.
See More

Learn more about

Back to Top