Databases Reference
In-Depth Information
How It Works
This works the same way all INSERT s work. You simply provide the primary keys as inte-
gers and the XML documents as strings. The query works just as expected, too.
Summary
This chapter covered the fundamentals of XML that every C# programmer needs to
know. It also showed you how to use the most frequently used T-SQL features for extract-
ing XML from tables and querying XML documents like tables. Finally, we discussed the
xml data type and gave you some practice using it.
How much more you need to know about XML or T-SQL and ADO.NET facilities
for using XML documents depends on what you need to do. As for many developers,
this chapter may be all you ever really need to know and understand. If you do more
sophisticated XML processing, you now have a strong foundation for experimenting
on your own.
In the next chapter, you will learn about database transactions.
Search WWH ::




Custom Search