Table of Contents

microsoft sql server 2005 stored procedure programming in t-sql & .net, third edition
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, Third Edition
byDejan Šunderi
McGraw-Hill/Osborne 2006 (704 pages)

Use this definitive resource to get key concepts, techniques, and best practices to help you take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages.

Table of Contents
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, Third Edition
Chapter 1 - The SQL Server 2005 Environment and Tools
Chapter 2 - Stored Procedure Design Concept
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
List of Figures
List of Tables
List of Sidebars

Back Cover

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

About the Author

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.

Projects that he has been involved with cover B2C and B2B e-commerce, financial, medical, document-management, mortgage, asset-management, insurance, real-estate, IT supply chain, process control, communication, data warehouse, and OLAP systems. Dejan has worked as a database architect, database and application developer, database administrator, team leader, project manager, writer, and technical trainer.

He is the author of SQL Server 2000 Stored Procedure Programming, and co-author of Windows 2000 Performance Tuning and Optimization and four other books, as well as numerous technical articles for several computer and professional publications.

His career started in Belgrade, Yugoslavia, where he graduated from the Faculty of Electrical Engineering. In 1995 he moved to Toronto, Canada, then in 2001 to Pittsburgh, PA. He is now back in Toronto working on a multi-terabyte database and leading a local organization of SQL Server professionals.