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
بدون عنوان
0
بدون عنوان
8
بدون عنوان
8
بدون عنوان
8
یادداشتهای مربوط به خلاصه یا چکیده
متن يادداشت
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.
یادداشتهای مربوط به سفارشات
منبع سفارش / آدرس اشتراک
OverDrive, Inc.
منبع سفارش / آدرس اشتراک
OverDrive, Inc.
شماره انبار
97EA94D5-36AC-4AEA-93E1-C5B4D14F6B1F
ویراست دیگر از اثر در قالب دیگر رسانه
عنوان
Professional SQL server 2005 CLR programming.
شماره استاندارد بين المللي کتاب و موسيقي
0470054034
عنوان به منزله موضوع
موضوع مستند نشده
Microsoft .NET Framework.
موضوع مستند نشده
Microsoft .NET Framework.
موضوع (اسم عام یاعبارت اسمی عام)
موضوع مستند نشده
Database management-- Computer programs.
موضوع مستند نشده
SQL (Computer program language)
موضوع مستند نشده
COMPUTERS-- Data Processing.
موضوع مستند نشده
Database management-- Computer programs.
موضوع مستند نشده
SQL (Computer program language)
مقوله موضوعی
موضوع مستند نشده
COM-- 018000
رده بندی ديویی
شماره
005
.
75/85
ويراست
22
رده بندی کنگره
شماره رده
QA76
.
73
.
S67
نشانه اثر
C655
2007eb
نام شخص به منزله سر شناسه - (مسئولیت معنوی درجه اول )