Chapter III.9. Advanced Query Topics
Sometimes you need to go beyond the basics and use some advanced methods to interact with your data. In this chapter, you discover some of those advanced methods.
Transactions are often used in stored procedures and can be very valuable when you want to control the success (or failure) of changes to your data. Full-text queries allow you to search text-type data with more power than the simple LIKE clause. The INNER JOIN statement retrieves data based on matches between two tables, but sometimes you want a listing of everything in one of the tables regardless of matches in the other table; OUTER JOIN statements allow you to do just that.
Moreover, XML data is becoming increasingly important in the storage of data due to its ease of use between platforms. When you start storing XML data, you'll want to be able to retrieve and modify it. The XML methods used to retrieve and modify XML data are demonstrated in the last section of this chapter.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
