SQL 2005 ¶Ôxml ÎļþÓë xmlÊý¾ÝµÄ²Ù×÷
ÓÉÓÚÊý¾Ý¿â¶ÔxmlÊý¾ÝÖ±½Ó´¦ÀíÓкܶàÓÅÊÆ£¬05Ò²¶ÔÕâ·½Ãæ¼ÓÇ¿Á˹¦ÄÜ¡£
µ«Õâ·½Ãæ×ÊÁÏÉÙ£¬ËùÒÔ×Ô¼º×öÁËһЩ×ܽᣬϣÍû»á¸ø´ó¼Ò´øÀ´°ïÖú
--charry0110(Ïþ·ç²ÐÔÂ)
--×÷Õߣº³Âº£Óê
--ÓÃSQL¶àÌõ¿ÉÒÔ½«¶àÌõÊý¾Ý×é³ÉÒ»¿ÃXMLÊ÷LÒ»´Î²åÈë
--½«XMLÊ÷×÷Ϊvarchar²ÎÊý´«ÈëÓÃ
--insert xx select xxx from openxml() µÄÓï·¨²åÈëÊý¾Ý
-----------------------------------µ¼È룬µ¼³öxml--------------------------
--1µ¼ÈëʵÀý
--µ¥¸ö±í
create table Xmltable(Name nvarchar(20),Nowtime nvarchar(20))
declare @s as nvarchar(2000);
set @s = N''
<Xmltables>
<Xmltable Name="1" Nowtime="1900-1-1">0</Xmltable>
<Xmltable Name="2" Nowtime="1900-1-1">0</Xmltable>
<Xmltable Name="3" Nowtime="1900-1-1">0</Xmltable>
<Xmltable Name="4" Nowtime="1900-1-1">0</Xmltable>
<Xmltable Name="5" Nowtime="1900-1-1">0</Xmltable>
</Xmltables>'';
declare @idHandle as int ;
EXEC sp_xml_preparedocument @idHandle OUTPUT, @s
insert into Xmltable(Name,Nowtime)
select * from openxml(@idHandle,N''/Xmltables/Xmltable'')
with dbo.xmltable
EXEC sp_xml_removedocument @idHandle
select * from Xmltable
-----------------------¶ÁÈëµÚ¶þ¸ö±íÊý¾Ý--------------------
create table Xmlta(Name nvarchar(20),Nowtime nvarchar(20))
declare @s as nvarchar(4000);
set @s =N''
<Xmltables>
<Xmltb Name="6" Nowtime="1900-2-1">0</Xmltable>
<Xmlta Name="11" Nowtime="1900-2-1">0</Xmlta>
</Xmltables>
Ïà¹ØÎĵµ£º
Microsoft SQL Server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ“¼ü”»ò“PK”£¬µ«ÕâʼÖÕ±íʾ“Ö÷¼ü”¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØÏµÏµÍ³ÖÐÊDz»ÔÊÐíµÄ¡£SQL Server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼Êøº ......
3¡£±íÄÚÈÝÈçÏÂ
-----------------------------
ID LogTime
1 2008/10/10 10:00:00
1 2008/10/10 10:03:00
1 2008/10/10 10:09:00
2 ¡ ......
<?php
require_once '../../smartyConfig/smartyConfig.class.php';
require_once '../../game/include/function.php';
require_once '../../game/include/config.php';
require_once '../../game/server/server.class.php';
require_once '../../game/include/db.class.php'; ......
×÷Õß Haidong Ji ·Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔǰµÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......
ansi_warningºÍansi_nulls Á½¸öÑ¡Ïî±ØÐë´ò¿ª£¬ºÃÏñ¶ÔϵͳҲûɶӰÏì¡£
Â¥Ö÷ÔÙ¼ì²éÒ»ÏÂÁ½¸öµØ·½£¬¾²âÊÔ£¬ÔÚҪʹÓ÷ֲ¼Ê½ÊÂÎñʱ£¬ÕâÊDZØÐëÒªÉèÖõġ£
1¡¢Á´½Ó·þÎñÆ÷ºÍÃû³Æ½âÎöÎÊÌâ
-- ´´½¨Á´½Ó·þÎñÆ÷
EXEC sp_addlinkedserver 'srv_lnk', 'ms', 'SQLOLEDB', '192.168.1. ......