Programming SQL Server 2005 / Bill Hamilton.

Format:

Book

Author/Creator:

Hamilton, Bill, 1964-

Language:

English

Subjects (All):

SQL server.

Client/server computing.

SQL (Computer program language).

Physical Description:

1 online resource (588 p.)

Edition:

First edition.

Place of Publication:

Beijing ; Sebastopol, California : O'Reilly, 2006.

Language Note:

English

System Details:

text file

Summary:

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on. Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The f

Contents:

Table of Contents; Preface; What You Need to Use This Book; Conventions Used in This Book; How to Contact Us; Safari® Enabled; Acknowledgments; Introduction; Contents of This Book; What's Not in This Book; Tools and Utilities; SQL Server Management Studio; Registered Servers; Object Explorer; Database server instance; Databases node; Security node; Server Objects node; Replication node; Management node; Notification Services node; SQL Server Agent node; Template Explorer; Solution Explorer; SQL Server Configuration Manager; SQL Server Surface Area Configuration; Database Engine Tuning Advisor

SQL Server ProfilerSQL Server Business Intelligence Development Studio; Visual Studio 2005; New Command-Line Utilities; SQL Server command-line tool (sqlcmd utility); T-SQL Enhancements; New Data Types; The xml Data Type; Large Value Data Types; T-SQL Language Enhancements; TOP; TABLESAMPLE; OUTPUT; Common Table Expressions (CTEs); SOME and ANY; ALL; PIVOT and UNPIVOT; APPLY; EXECUTE AS; New Ranking Functions; ROW_NUMBER(); DENSE_RANK(); NTILE(); Error Handling; Data Definition Language (DDL) Triggers; Metadata; Introduction to Common Language Runtime (CLR) Integration

CLR Integration Design ObjectivesEnabling CLR Integration; Required .NET Namespaces; Types of CLR Routines; Hello World Example; Command-Line Compiler; DDL Support for CLR Integration; CLR Routine Metadata; sys.assemblies; sys.assembly_files; sys.assembly_modules; sys.assembly_references; sys.assembly_types; Assembly Management; CREATE ASSEMBLY; ALTER ASSEMBLY; DROP ASSEMBLY; User-Defined Functions; CREATE FUNCTION; ALTER FUNCTION; DROP FUNCTION; Stored Procedures; CREATE PROCEDURE; ALTER PROCEDURE; DROP PROCEDURE; Metadata; User-Defined Aggregate Functions; CREATE AGGREGATE; DROP AGGREGATE

User-Defined TypesCREATE TYPE; DROP TYPE; Metadata; Triggers; CREATE TRIGGER; ALTER TRIGGER; DROP TRIGGER; Metadata; ADO.NET In-Process Extensions Supporting CLR Programming; SqlContext Object; SqlPipe Object; SqlTriggerContext Object; SqlDataRecord Object; Custom Attributes for CLR Routines; SQL Server Data Types in the .NET Framework; Testing and Debugging CLR Routines; Programming SQL Server CLR Routines; Scalar-Valued Functions; Table-Valued Functions; Stored Procedures; User-Defined Aggregate Functions; User-Defined Types; Triggers; DML Triggers; DDL Triggers

.NET Client-Side ProgrammingSQL Native Client Programming; SQLXML 4.0; SQLXML Managed Classes; SqlXmlCommand; SqlXmlParameter; SqlXmlAdapter; Using SQLXML Managed Classes; Executing a query; Using parameters in a query; Handling an exception; Retrieving an XmlReader object; Processing an XML result set on the client; Filling a DataSet; Applying an XSLT transformation to the XML result set; Annotated Mapping Schemas; XML Template Queries; UpdateGrams; DiffGrams; Exception Message Box; XML Data; xml Data Type; Creating xml Data Type Columns and Variables; Columns; Variables; Limitations

Creating xml Data Type Instances

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed October 12, 2013).

ISBN:

9781449390921

1449390927

9781449391591

1449391591

OCLC:

780425085