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

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET by Dejan Sunderic
English | May 18, 2006 | ISBN: 0072262281 | 664 Pages | CHM | 19 MB

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 ToolsChapter 2: Stored Procedure Design ConceptsChapter 3: Basic Transact-SQL Programming ConstructsChapter 4: FunctionsChapter 5: Composite Transact-SQL Constructs: Batches, Scripts, and TransactionsChapter 6: Error HandlingChapter 7: Special Types of Stored ProceduresChapter 8: ViewsChapter 9: TriggersChapter 10: User-defined FunctionsChapter 11: Fundamentals of .NET Programming in SQL Server 2005Chapter 12: Fundamentals of CLR Stored Procedure DevelopmentChapter 13: CLR Functions and TriggersChapter 14: CLR Database Objects Advanced TopicsChapter 15: Advanced Stored Procedure ProgrammingChapter 16: DebuggingChapter 17: Source Code ManagementChapter 18: Database DeploymentChapter 19: SecurityChapter 20: Stored Procedures for Web Search EnginesChapter 21: Interaction with the SQL Server EnvironmentAPPENDIX A: NAMING CONVENTIONSAPPENDIX B: STORED PROCEDURE COMPILATION, STORAGE, AND REUSEAPPENDIX C: DATA TYPES IN SQL SERVER 2005INDEX



Find us on Facebook