Pro T-SQL 2008 Programmers Guide

最新推荐文章于 2025-04-23 08:43:37 发布

原创最新推荐文章于 2025-04-23 08:43:37 发布 · 596 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #triggers #features #merge #xml #include

Sql Server 专栏收录该内容

88 篇文章

订阅专栏

本书全面介绍了 SQL Server 2008 中 Transact-SQL 的新特性和现有功能，包括存储过程、触发器编写、XML 数据操作、SQL CLR 集成等内容，并提供丰富的实例和源代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of TransactCSQL functionality in SQL Server 2008 in his book Pro TCSQL 2008 Programmers Guide. Fully functioning examples and downloadable source code bring Coles technically accurate and engaging treatment of TransactCSQL into your own hands. StepCbyCstep explanations ensure clarity, and an advocacy of bestCpractices will steer you down the road to success.

Pro TCSQL 2008 Programmers Guide is every developers key to making full use of SQL Server 2008s powerful, builtCin TransactCSQL language. TransactCSQL is the language developers and DBAs use to interact with SQL Server. Its 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 marketCleading XML feature set, and support for encryptionall of which are covered in this book

What youll learn
*Write stored procedures, functions, and triggers using TransactCSQL
*Apply bestCpractices when centralizing procedural logic inside your SQL Server database.
*Seamlessly work with XML data using XQuery, XPath, and the XML type.
*Use SQLCLR to write .NET code that runs inside SQL Server.
*Implement fullCtext search within your database.
*Load data more efficiently using the new MERGE statement.
*Learn about the new geography type for storing spatial data.

http://rapidshare.com/files/144250689/143021001X.rar
http://depositfiles.com/files/7869540