| Home / General / XML Data-type Usage By Other SQL Server 2005 Features |
digWin is a community news sharing site for Microsoft Techies. Share interesting news/links and rate them!
XML Data-type Usage By Other SQL Server 2005 Features
posted by mvrok (14) 15 months ago (blogs.msdn.com)
Several of the other features within SQL Server 2005 leverage the XML data-type to pass information around. For example, both Service Broker and triggers transfer data around the server in XML data-type instances. This means that you can easily leverage the power of the XQuery language and other XML data-type methods when using these features.
To illustrate this, we create a simple trigger on our database that fires when we create a new table:
create trigger CreateTableTrigger on database for create_table asselect eventdata()
In this case, our trigger is simply ou
Microsoft news, tips and tricks search
Comments
Add a comment
Post voted by 1 digWinners
Featured Links
-
Free Download Trial: SharePoint Migration, Backup and Recovery Software
DocAve: Enterprise, full-fidelity backup & recovery software for SharePoint provides essential protection & management tools, and allows for a data migration from Exchange Public Folders in to SharePoint 2007 & 2003.
User
Sponsor
Anti spam filter for mail servers
Anti spam, anti phishing and email management software for Exchange/SMTP/Lotus. Download a FREE trial!
Anti spam, anti phishing and email management software for Exchange/SMTP/Lotus. Download a FREE trial!
Featured
Categories
Upcoming NEW
- How to sequence Microsoft Money 2007
- Howto: Stop Backup Exec from failing entire backup jobs when corrupt files are encountered
- A Closer Look at Preparing Active Directory for Exchange 2007 (Part 5)
- Convert NSF to PST
- http://www.good-handbag.com/items/new_products.html
- Aimersoft promoting "Buy 1 Get 1 Free" iPod, iPhone, Zune and PSP software for Christmas
- Pass4side 642-522 exam Q&A
- Pass4side 642-432 exam Q&A
- Pass4side 642-432 exam Q&A
- Pass4side 642-432 exam Q&A
- Pass4side 642-502 exam Q&A
- Pass4side 642-432 exam Q&A
- Pass4side 642-453 exam Q&A
- Pass4side 642-445 exam Q&A
- Pass4side 642-444 exam Q&A
- Pass4side 642-432 exam Q&A
- Certifyme 70-639 Dumps
- Certifyme 70-556 Dumps
- Certifyme Dumps 70-648
- Certifyme Dumps 70-638
Recent comments
- Aimersoft summer special offer-Buy DVD to iPod get iPod Video Converter free by Anonymous user
- Assigning host LPT1 in MS virtual PC 2007 sp1 by glucy0730 (0)
- Will Redskins make playoffs this year? by Anonymous user
- Replica New Handbags,Evening Bag ,Cosmetic Make-up ,Hobo Metallic ,Oversized Waist Bag, Purse Wallet Shopping Bag ,Tote trolley by Anonymous user
- Replica Handbags,bag,shopping,new Products by ajdv (0)
- Do you like the special package by Anonymous user
- Access Database Recovery by Anonymous user
- Replica New Handbags,Evening Bag ,Cosmetic Make-up ,Hobo Metallic ,Oversized Waist Bag, Purse Wallet Shopping Bag ,Tote trolley by ajdv (0)
- Replica Louis Vuitton Monogram Vernis Patent Leather Pomme d'Amour Pochette Wallet LV M9140F by lisude (0)
- Cyber Monday by Anonymous user
