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

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>


Ïà¹ØÎĵµ£º

ÈçºÎɾ³ý SQL Server ±íÖеÄÖØ¸´ÐÐ

    Microsoft SQL Server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ“¼ü”»ò“PK”£¬µ«ÕâʼÖÕ±íʾ“Ö÷¼ü”¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØÏµÏµÍ³ÖÐÊDz»ÔÊÐíµÄ¡£SQL Server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼Êøº ......

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 ¡ ......

perlÀûÓÃÄÚ´æÊ¹ÓÃsqlÓï¾ä

 ´ó¼ÒºÃ£¡×î½üÓÖÓÐÁËһЩģ¿éÓ÷¨µÄÐĵã¬ÄǾÍÊÇÀûÓÃÄ£¿éʹÄãµÄÄÚ´æ±ä³ÉÒ»¸öÐéÄâµÄÊý¾Ý¿âģʽ£¬Ê¹Äã¿ÉÒÔÔÚûÓÐÊý¾Ý¿âµÄÇé¿öÏ£¬½«txtÎļþµÄÊý¾Ý½øÐÐ sqlÓï¾ä´¦Àí£¬¸Ð¾õºÜÐÂÏʰɣ¬²»¹ýÕâ¸ö²»Óøе½¾ªÑÈ£¬PerlÒ»Ö±ÊǺÜÍêÃÀµÄ£¬¹þ¹þ£¬ÄÇÎÒÃǾÍÀ´¿´¿´Õâ¸öÉñÆæ°É£¡
ÐèÒª°²×° Ä£¿é£º
SQl::Library;
DBI 
ÏÂÃæÊdzÌÐò ......

SQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.

 ±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
declare   @iDays   int 
declare   @dt   varchar(50) 
set   @dt=@Year+'-'+@Month+'-01'
select @iDays=day(dateadd( ......

SQLÐÔÄÜÓÅ»¯£¨²»¶Ï×ܽᣩ


1.²éѯµÄÄ£ºýÆ¥Åä
¡¡¡¡¾¡Á¿±ÜÃâÔÚÒ»¸ö¸´ÔÓ²éѯÀïÃæÊ¹Óà LIKE '%parm1%'—— ºìÉ«±êʶλÖõİٷֺŻᵼÖÂÏà¹ØÁеÄË÷ÒýÎÞ·¨Ê¹Óã¬×îºÃ²»ÒªÓá£
¡¡¡¡½â¾ö°ì·¨:
¡¡¡¡ÆäʵֻÐèÒª¶Ô¸Ã½Å±¾ÂÔ×ö¸Ä½ø£¬²éѯËٶȱã»áÌá¸ß½ü°Ù±¶¡£¸Ä½ø·½·¨ÈçÏ£º
      ¡¡¡¡a¡¢ÐÞ¸Äǰ̨³ÌÐò—&mdas ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ