PRO T-SQL 2008 PROGRAMMER'S GUIDE

Pro Tâ??SQL 2008 Programmerâ??s Guide is every developerâ??s key to making full use of SQL Server 2008â??s powerful, builtâ??in Transactâ??SQL language. Transactâ??SQL 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 marketâ??leading XML feature set, and support for encryptionâ??all of which are covered in this book

What youâ??ll learn

• Write stored procedures, functions, and triggers using Transactâ??SQL
• Apply bestâ??practices 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 fullâ??text search within your database.
• Load data more efficiently using the new MERGE statement.
• Learn about the new geography type for storing spatial data.

Pro Tâ??SQL 2008 Programmerâ??s Guide is written for SQL Server and Transactâ??SQL developers who want to implement bestâ??practices and take full advantage of all that SQL Server has to offer. .NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hardâ??won solutions to problems you will face in your professional programming career.

Idioma: SIN DEFINIR