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

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
By:Sunderic, Dejan;
Pub Date:June 8th 2006
Format:Paperback 664 pages
ISBN:0072262281 / 9780072262285
Your Price:$62.00 ADD TO CART
More Information




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


Backcover

Author Information

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Apr 19th, 2016
Your Price: $70.00
Owl Image

Date: Apr 11th, 2016
Your Price: $65.00
Owl Image

Date: Oct 23rd, 2015
Your Price: $60.00
Owl Image

Date: Oct 22nd, 2015
Your Price: $50.00
Owl Image

Date: Oct 22nd, 2015
Your Price: $50.00
Owl Image

Date: Oct 22nd, 2015
Your Price: $40.00
Owl Image

Date: Sep 2nd, 2015
Your Price: $70.00
Owl Image

Date: Aug 28th, 2015
Your Price: $90.00
Owl Image

Date: Aug 24th, 2015
Your Price: $90.00
Owl Image

Date: Jul 4th, 2015
Your Price: $40.00
Owl Image

Date: Jul 3rd, 2015
Your Price: $65.00
Owl Image

Date: Jun 24th, 2015
Your Price: $65.00
Owl Image

Date: Jun 12th, 2015
Your Price: $60.00
Owl Image

Date: Jun 12th, 2015
Your Price: $70.00
Owl Image

Date: Jun 8th, 2015
Your Price: $60.00