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

Customers who bought this, also bought: MCTS Self-Paced Training Kit (Exam 70-562): Microsoft® .NET Framework 3.5 ASP.NET Application Development (Pro - Certification) (Hardcover) Beginning Transact-SQL with SQL Server 2000 and 2005 Pro SQL Server 2005 Service Broker jQuery Recipes: A Problem-Solution Approach Pro SQL Server 2005 MCTS Self-Paced Training Kit (Exam 70-503): Microsoft .NET Framework 3.5-Windows Communication Foundation Wrox's Sql Server 2005 Express Edition Starter Kit Effective C# (Covers C# 4.0): 50 Specific Ways to Improve Your C#, 2nd Edition .Net for Delphi Programmers Microsoft .NET Framework 2.0 Poster Pack

by: Sunderic

Notify me when in stock

On-line Price: $80.00 (includes GST) Paperback package 664 20%Off Retail Price You save: $20.00 Please call us to check availability	Retail Price: $100.00 Publisher: MCGRAW-HILL,2006-01-05 Category: Level: ISBN: 0072262281 ISBN13: 9780072262285
Add to Shopping Cart

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

Contents Back to top

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