Beschreibung
Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact-SQL functionality in SQL Server 2008 in his book, Pro T-SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles' technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Pro TSQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, builtin TransactSQL language. TransactSQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and marketleading XML feature set, and support for encryptionall of which are covered in this book
Autorenportrait
InhaltsangabeFoundations of T-SQL.- T-SQL 2008 New Features.- Tools of the Trade.- Procedural Code and CASE Expressions.- User-Defined Functions.- Stored Procedures.- Triggers.- Encryption.- Common Table Expressions and Windowing Functions.- Integrated Full-Text Search.- XML.- XQuery and XPath.- Catalog Views and Dynamic Management Views.- SQL CLR Programming.-.NET Client Programming.- Data Services.- New T-SQL Features.- Error Handling and Dynamic SQL.- Performance Tuning.
