This book is a preview of Microsoft's SQL Server 2005 database. SQL Server 2005 is completely.NET integrated, allowing developers to program in any.NET language, conveniently inside the database. This book is a first look at and illustrates the new.NET capabilities of the database. This book has strong appeal to three core audiences: SQL Server developers,.NET developers, and database administrators. After reading this book, developers will be able to build robust, useful and intelligent assemblies that are safe to execute and secure for the organization. TOC:Introduction.- Building.NET Assemblies: Best Practices.- Security and Execution Contexts.- Error Handling.- Stored procedures.- User Defined Functions.- User Defined Data Types.- User Defined Aggregations.- Extending Triggers.- Using XML.- Appendix A:.NET Primer.- Appendix B: C# Code Examples.
Auflage
Sprache
Verlagsort
Zielgruppe
Für Beruf und Forschung
Für höhere Schule und Studium
Beginner-intermediate-advanced, audience: SQL Server developers and DBAs
Maße
Höhe: 235 mm
Breite: 178 mm
Dicke: 15 mm
ISBN-13
978-1-59059-412-4 (9781590594124)
Schweitzer Klassifikation
Robin Dewson has been hooked on programming since he bought his first computer in 1980, a Sinclair ZX80. Dewson's first creation was a Visual FoxPro application that could run a Fantasy League system, and realized the importance of being both GUI- and database-conscious. Dewson started working closely with Visual Basic, versions 5 to.NET, and worked simultaneously with SQL Server 6.5, through the current SQL Server Yukon, participating in several SQL Server betas along the way. Dewson authored Beginning SQL-Server 2000 Programming, and has co-authored and contributed to numerous other books. Dewson is a consultant mainly in London, and has been there for nearly 8 years. He has also been developing a rugby related website, as well as his own personal site at, www.fat-belly.com.
1. Introduction2. Building .NET Assemblies: Best Practices3. Security and Execution Contexts4. Error Handling.5. Stored procedures6. User Defined Functions7. User Defined Data Types8. User Defined Aggregations9. Extending Triggers10. Using XMLAppendix A: .NET PrimerAppendix B: C# Code Examples
