Dejan Sunderic

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

• Broschiertes Buch

Produktbeschreibung

Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this guide explains how to take full advantage of stored procedures: operations that are stored with the database server, allowing access to all clients. The book covers the design of stored procedures in both T-SQL and CLR languages such as Csharp and Visual Basic .NET and readers will learn to develop programmable database objects and scalable Web-based applications.

Produktdetails

• Essential Skills for Database Professionals
• Verlag: McGraw-Hill Professional / Osborne
• 3. Aufl.
• Seitenzahl: 664
• Erscheinungstermin: 1. Mai 2006
• Englisch
• Abmessung: 231mm x 187mm x 40mm
• Gewicht: 1130g
• ISBN-13: 9780072262285
• ISBN-10: 0072262281
• Artikelnr.: 15049081

Autorenporträt

Dejan Sunderic (Toronto, Ontario) MCSD is the Principal Consultant at Sage Information Consultants, Inc., a consulting company based in Toronto specializing in development and infrastructure solutions.

Inhaltsangabe

From the 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