Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

.NET SQLServer2005 XML×Ö¶Î

//ÕâÊÇÌí¼Ó 
private void button1_Click(object sender, EventArgs e)
        {
            string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
            using (SqlConnection conn = new SqlConnection(s))
            {
                using (SqlCommand cmd1 = new SqlCommand("INSERT testxml VALUES(@ID, @XmlData)", conn))
                {
                    conn.Open();
                    cmd1.Parameters.Add("@ID", SqlDbType.Int, 4);
                    cmd1.Parameters[0].Value = 2;
                    cmd1.Parameters.Add("@XmlData", SqlDbType.Xml);
                    cmd1.Parameters[1].Value = GetXmlData();
                    cmd1.ExecuteNonQuery();
                 
                }
            }
        }
     &nbs


Ïà¹ØÎĵµ£º

grails½âÎöxmlÎļþ

xmlÎļþ£º
<?xml version="1.0" encoding="iso-8859-1"?>
<Products>
    <product>
        <name>lovechoosesun</name>
        <buyNowURL>http://merch.danecook ......

Oracle9ÖÐXML SQL Utility¼¼ÊõÖ¸µ¼(java)

¡ö     ¿ª·¢Ç°ÒªÇóÅäÖÃ
¡ö     Select XML¸ñʽÊý¾Ý
¡ö     Insert XML¸ñʽÊý¾Ý
¡ö     Updata XML¸ñʽÊý¾Ý
¡ö     Delete XML¸ñʽÊý¾Ý
¿ª·¢Ç°ÒªÇóÅäÖÃ
±ØÐë°²×°Oracle¿Í»§¶Ë
°ÑClasspathÖ¸Ïò
classes111.zip ......

XML µÄתÒÆ×Ö·û


ºÍ           &      & amp;  
µ¥
ÒýºÅ     '      & apos;  
Ë«Òý
ºÅ     "   ......

»ñÈ¡sqlserverÊý¾Ý¿âÖÐËùÓп⡢±í¡¢×Ö¶ÎÃûµÄ·½·¨

»ñÈ¡sqlserverÊý¾Ý¿âÖÐËùÓп⡢±í¡¢×Ö¶ÎÃûµÄ·½·¨
2009Äê03ÔÂ12ÈÕ ÐÇÆÚËÄ ÏÂÎç 12:51
1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ± ......

XML ÖУ¬ÓÐ 5 ¸öÔ¤¶¨ÒåµÄʵÌåÒýÓãº


&lt;
<
СÓÚ
&gt;
>
´óÓÚ
&amp;
&
ºÍºÅ
&apos;
'
µ¥ÒýºÅ
&quot;
"
ÒýºÅ
 
×¢ÊÍ£ºÔÚ XML ÖУ¬Ö»ÓÐ×Ö·û "<" ºÍ "&" ȷʵÊÇ·Ç·¨µÄ¡£´óÓÚºÅÊǺϷ¨µÄ£¬µ«ÊÇÓÃʵÌåÒýÓÃÀ´´úÌæËüÊÇÒ»¸öºÃÏ°¹ß¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ