|
Free ebooks
 Free database ebooks SQL The Expert's Voice in SQL Server - Pro T-SQL 2005 Programmers Guide
|
||||||||
 Chapter 1: The Role of T-SQL. This chapter provides a brief history of T-SQL and the ANSI SQL standards. It also provides some basic hints and tips for getting the most out of your T-SQL code and maintaining it over the long term.Chapter 2: Tools of the Trade. SQLCMD and SQL Server Management Studio (SSMS) are new tools designed to replace osql, Enterprise Manager, and Query Analyzer. The online help system and Adventure-Works sample database are also discussed. Chapter 3: T-SQL for SQL Server 2000 Programmers. SQL Server 2005 provides several enhancements that SQL Server 2000 developers will be able to take advantage of immediately. This chapter covers new SQL Server 2005 data types, Common Table Expressions (CTEs), and new operators, keywords, and functions. Chapter 4: Control-of-Flow and CASE Expressions. SQL Server T-SQL has always had procedural extensions built right into it. This chapter covers ANSI SQL three-valued logic, T-SQL procedural control-of-flow statements, SQL CASE expressions, and CASE-derivative functions. Chapter 5:User-Defined Functions. This chapter discusses the three flavors of T-SQL user-defined functions: scalar userdefined functions, multistatement table-valued functions, and inline table-valued functions. Examples are provided, with tips on getting the most out of your own userdefined functions. Chapter 6: Stored Procedures. SQL Server provides stored procedures, which allow you to create server-side T-SQL modules. This chapter discusses creation and management of stored procedures, stored procedure parameters, recursion, and scope. Chapter 7: Triggers. SQL Server 2005 supports classic Data Manipulation Language (DML) triggers that perform actions when you insert, update, or delete rows in a table. Data Definition Language (DDL) triggers, which fire in response to DDL events, are new to SQL Server 2005 T-SQL. Chapter 8: T-SQL Encryption. SQL Server 2005 T-SQL includes a whole new set of statements to manage encryption keys and certificates, and a wide range of built-in functions to encrypt and decrypt data. This chapter explores the new T-SQL encryption key management and data encryption and decryption tools. Chapter 9: Error Handling and Debugging. This chapter discusses methods for handling errors in your T-SQL code, including legacy error handling and the new TRY...CATCH structured error-handling statements. Also discussed is the built-in Visual Studio T-SQL debugging tools. Chapter 10: Dynamic SQL. The risks (and how to avoid them) and rewards of dynamic SQL are discussed in this chapter. Client-side parameterization, SQL injection, and validation are also covered. Chapter 11: XML. This chapter begins with a discussion of the enhancements to legacy SQL Server XML functionality provided by SQL Server 2005. The chapter continues with an in-depth discussion of SQL Server’s new XML functionality, including the new xml data type and its methods, XML schema collections, typed and untyped XML, XML indexes, and XSL Transformations. Chapter 12: XQuery and XPath. This chapter expands on the discussion of the enhanced XML functionality that began in Chapter 11 by providing an in-depth discussion of the XPath and XQuery capabilities provided by SQL Server 2005. Chapter 13: SQL Metadata. SQL Server 2005 provides more ways than ever to retrieve metadata about your server and database objects. This chapter covers SQL Server catalog views, compatibility views, ANSI-compatible INFORMATION_SCHEMA views, and system stored procedures. Chapter 14: SQLCLR Programming. SQL Server 2005’s Common Language Runtime integration offers new and exciting possibilities for expanding the power and functionality of your SQL Server–based applications. Chapter 15: .NET Client Programming. The best database in the world is only as useful as its client-side application, and the .NET Framework provides several tools for client-side SQL Server connectivity. Chapter 16: HTTP Endpoints. SQL Server’s new HTTP endpoints allow you to expose stored procedures and userdefined functions as web methods. Download free pdf ebooks for sql:The Expert's Voice in SQL Server - Pro T-SQL 2005 Programmers Guide
|
| More free ebooks | |