| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1047791
|
| Doc. No
|
:
|
b802161
|
| Main Entry
|
:
|
Comingore, Derek,1978-
|
| Title & Author
|
:
|
Professional SQL server 2005 CLR programming : : with stored procedures, functions, triggers, aggregates, and types /\ Derek Comingore, Douglas Hinson.
|
| Publication Statement
|
:
|
Indianapolis, IN :: Wrox/Wiley Technology Pub.,, ©2007.
|
| Series Statement
|
:
|
Wrox professional guides
|
| Page. NO
|
:
|
1 online resource (xxii, 409 pages) :: illustrations.
|
| ISBN
|
:
|
0470121068
|
|
|
:
|
: 1280741651
|
|
|
:
|
: 6610741654
|
|
|
:
|
: 9780470121061
|
|
|
:
|
: 9781280741654
|
|
|
:
|
: 9786610741656
|
|
|
:
|
0470054034
|
|
|
:
|
9780470054031
|
| Notes
|
:
|
"Programmer to programmer"--Cover.
|
|
|
:
|
Includes index.
|
| Contents
|
:
|
Professional SQL Server 2005 CLR Programming; About the Authors; About the Authors; Credits; Contents; Acknowledgments; Introduction; Who This Book Is For; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Introducing SQL CLR; What is SQL CLR?; The Evolution of SQL CLR; Supported SQL CLR Objects; The .NET Architecture; Hosting the CLR; SQL CLR Architecture; Application Domains; The CLR Security Model; Key SQL CLR Decisions; SQL CLR Barriers of Entry; SQL Server 2005 SQL CLR support; Visual Studio 2005 SQL CLR support
|
|
|
:
|
Chapter 10: CLR Administration and Security.NET for the DBA and System Admin; Security and SQL Server-Hosted CLR; SQL CLR Assembly Metadata; Managing the SQL CLR Lifecycle; Monitoring and Troubleshooting SQL CLR; Summary; Chapter 11: Case Study; Business Case; DateTime Calculation Background; Solution Approach; Solution Prerequisites; T-SQL-Based Solution; SQL CLR-Based Solution; Solution Comparisons; Summary; Index
|
|
|
:
|
Chapter 7: The .NET Framework's Base Class LibraryAccessing External Data Sources; Building Effective Monitoring Tools; Summary; Chapter 8: Using SQL CLR Stored Procedures in Your Applications; SQL CLR Application Usage Architecture; Console Apps and SQL CLR Extended Procs; WinForms and SQL CLR UDTs; Web Forms and SQL CLR Aggregates; Integration Services and SQL CLR TVFs; Reporting Services and SQL CLR TVFs; Summary; Chapter 9: Handling Errors in CLR Stored Procedures; Exception-Handling Mechanisms Used in SQL CLR; SQL CLR Error-Handling Strategies; Summary
|
|
|
:
|
Managed Stored ProceduresManaged Functions; Managed Triggers; Managed Aggregates; Managed Types; Summary; Chapter 5: Comparing T-SQL with Managed Code; Syntactic Comparisons; Organizational Comparison; Capability Comparison; Performance and Other Comparisons; Summary; Chapter 6: Replacing Extended Stored Procedures, Functions, and Other T-SQL Objects; Historical Perspective on Extended Stored Procedures; Why Replace XPs with SQL CLR?; SQL CLR Replacements for XPs; Extended Stored Procedures for Mere Mortals; Replacing OLE Automation; Creating System SPs and UDFs; Summary
|
| Abstract
|
:
|
Chapter 2: Your First CLR Stored Procedure; Setting Up SQL Server Express and the AdventureWorks Database; The Mechanics of a Creating and Deploying a CLR Routine; Enabling CLR in SQL Server 2005; Creating Your First SQL CLR Routine without VS2005; How SQL Server Manages Assemblies; Creating Your First CLR User-Defined Function; Using Visual Studio to Create a CLR Routine; Suggested Conventions; Removing SQL CLR Objects; Summary; Chapter 3: SQL CLR Structure and Common Tasks; SQL CLR Code Structure; SQL CLR Common Tasks; Summary; Chapter 4: Creating SQL CLR Objects
|
|
|
:
|
SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities. Here's the reference you'll want on your desk as you develop SQL CLR solutions. It helps you decide whether to use SQL CLR, how to lock down security, and lear.
|
| Subject
|
:
|
Database management-- Computer programs.
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
COMPUTERS-- Data Processing.
|
| Subject
|
:
|
Database management-- Computer programs.
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
Microsoft .NET Framework.
|
|
|
:
|
Microsoft .NET Framework.
|
| Dewey Classification
|
:
|
005.75/85
|
| LC Classification
|
:
|
QA76.73.S67C655 2007eb
|
| Added Entry
|
:
|
Hinson, Douglas,1968-
|