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

by Sunderic, Dejan

• ISBN13: 9780072262285
• ISBN10: 0072262281
• Edition: 3rd
• Format: Paperback
• Copyright: 2006-06-08
• Publisher: McGraw-Hill Education

Summary

Create and Use Stored Procedures for Optimal Database PerformanceDevelop 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

Author Biography

Dejan Sunderic, MCSD, MCDBA (Canada) is a Database Consultant currently engaged in Canadian Imperial Bank of Commerce (CIBC) in Toronto. Dejan's focus is on OLTP, data warehousing, OLAP projects on Microsoft SQL Server, providing consulting and project management services to the clients. Prior to joining CIBC, Dejan was participating as software consultant, DBA, architect, project manager or project leader in different development and financial organizations: FreeMarkets Inc. (Pittsburgh, PA), Chapters (Indigo.ca), SHL SystemHouse, Wells Fargo Bank, Sofcore Systems, AIS, Maxium Financial Services, Rothmans, Benson & Hedges, etc. Dejan authored the two previous editions of SQL Server Stored Procedure Programming and is the President of the Toronto SQL Server User Group.

Table of Contents

Part 1: Introduction

Chapter 1: SQL Server 2005 Environment

Part 2: T-SQL Programming

Chapter 2: T-SQL Stored Procedure Design Concepts

Chapter 3: Basic T-SQL Constructs

Chapter 4: Functions

Chapter 5: Batches and Scripts

Chapter 6: Special Types of T-SQL Stored Procedures

Chapter 7: Views

Chapter 8: Triggers

Chapter 9: User-Defined Functions

Part 3: .NET Programming

Chapter 10: Fundamentals of Database Object Programming in .NET

Chapter 11: Programming CLR Functions

Chapter 12: Programming CLR Stored Procedures

Chapter 13: Programming CLR Types

Part 4: Professional Development

Chapter 14: Advanced T-SQL Programming

Chapter 15: Debugging

Chapter 16: Source Code Management

Chapter 17: Database Deployment

Chapter 18: Security

Chapter 19: Interaction with the SQL Server Environment

Chapter 20: SP for Web Search Engines