#副標=SQL 2005搶先導覽
#大標=XML與SQL資料庫的新火花
#眉標= SQL 2005
#作者=文／李明儒




=========== box 程式1 ================
<Survey Recipient=”Jeffrey”>
  <Seminar><Yes>資安</Yes></Seminar>
  <Tools>
    <dotNET>VS.NET 2002</dotNET>
    <dotNET>VS.NET 2003</dotNET>
    <Java>JBuilder</Java>
  </Tools>
  <Databases>
    <Sql>SQL 2000</Sql>
    <Oracle>Oracle 9i</Oracle>
    <Oracle>Oracle 10g</Oracle>
   </Databases>
</Survey>
============== end ==============





================= box 程式2 ==============
INSERT INTO SurveyData (Content) VALUES (
N‘<Survey Recipient=”George”>
<Seminar><No>工作時間太忙</No></Sminar>
<Tools><Java>JBuilder</Java></Tools>
<Databases><Oracle>Oracle 8i</Oracle></Databases></Survey>’)
==================== end =================





================= box 程式3 ==============
DECLARE @data XML
SET @data=N‘<Survey Recipient=”Mary”>
<Seminar><Yes>軟體工程</Yes></Sminar>
<Tools><dotNET>VS.NET 2003r</dotNET></Tools>
<Databases><Sql>SQL 2000</Sql></Databases></Survey>’
INSERT INTO SurveyData (Conent) VALUES (@data)
================== end ===================




============== box 程式4 =============
	CREATE PRIMARY XML INDEX idx_Content ON SurveyData(Content)
	CREATE XML INDEX idx_Content_Path ON SurveyData(Content)
	USING XML INDEX idx_Content FOR PATH
================ end =================