Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.

SIGN UP TODAY

0071491708

Date

May 18, 2006

Format

Mixed media product, 664 pages

Other Formats


ISBN

0072262281 / 9780072262285

$

Your Price

62.00



Overview


Main description

Create and Use Stored Procedures for Optimal Database Performance

Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.

Essential Skills for Database Professionals

  • Group and execute T-SQL statements using batches, scripts, and transactions
  • Create user-defined, system, extended, temporary, global temporary, and remote stored procedures
  • Develop and manage stored procedures using C# and Visual Basic .NET
  • Implement database access using ADO.NET
  • Create CLR user-defined functions and triggers
  • Implement reliable debugging and error handling techniques and security measures
  • Manage source code in a repository such as Visual SourceSafe
  • Create stored procedures for web search engines
  • Use system and extended stored procedures to interact with the SQL Server environment


Table of contents

Chapter 1: The SQL Server 2005 Environment and Tools Chapter 2: Stored Procedure Design Concepts Chapter 3: Basic Transact-SQL Programming Constructs Chapter 4: Functions Chapter 5: Composite Transact-SQL Constructs: Batches, Scripts, and Transactions Chapter 6: Error Handling Chapter 7: Special Types of Stored Procedures Chapter 8: Views Chapter 9: Triggers Chapter 10: User-defined Functions Chapter 11: Fundamentals of .NET Programming in SQL Server 2005 Chapter 12: Fundamentals of CLR Stored Procedure Development Chapter 13: CLR Functions and Triggers Chapter 14: CLR Database Objects Advanced Topics Chapter 15: Advanced Stored Procedure Programming Chapter 16: Debugging Chapter 17: Source Code Management Chapter 18: Database Deployment Chapter 19: Security Chapter 20: Stored Procedures for Web Search Engines Chapter 21: Interaction with the SQL Server Environment APPENDIX A: NAMING CONVENTIONS APPENDIX B: STORED PROCEDURE COMPILATION, STORAGE, AND REUSE APPENDIX C: DATA TYPES IN SQL SERVER 2005 INDEX


Author comments

Dejan Šunderić, MCDBA, is the principal consultant at Trigon Blue, Inc., and the president of the Toronto SQL Server User Group. He specializes in database and application development on the SQL Server platform.


Back cover copy

 

Create and Use Stored Procedures for Optimal Database Performance

Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.

Essential Skills for Database Professionals

  • Group and execute T-SQL statements using batches, scripts, and transactions
  • Create user-defined, system, extended, temporary, global temporary, and remote stored procedures
  • Develop and manage stored procedures using C# and Visual Basic .NET
  • Implement database access using ADO.NET
  • Create CLR user-defined functions and triggers
  • Implement reliable debugging and error handling techniques and security measures
  • Manage source code in a repository such as Visual SourceSafe
  • Create stored procedures for web search engines
  • Use system and extended stored procedures to interact with the SQL Server environment

 





Copyright 2014 McGraw-Hill Global Education Holdings, LLC

WELCOME!

Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.



Yes, I want to receive other special offer.