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

¾­µäsqlÓï¾ä

Ò»¡¢Ñ­»·
create table tb(
   col1 varchar(1),
   col2 varchar(2)

insert tb(col1,col2)values('0','0')
 go 10000000
¶þ¡¢Êý¾ÝºÏ²¢
if object_id('[order]') is not null drop table [order]
go
create table [order]([orderid] int,[ordertype] varchar(1))
insert [order]
select 1,'A' union all
select 2,'B'
if object_id('[order_car]') is not null drop table [order_car]
go
create table [order_car]([orderid] int,[carno] varchar(100))
insert [order_car]
select 1,'10' union all
select 1,'20' union all
select 2,'30'
select
  b.orderid,
  a.ordertype,
  carno=stuff((select ','+ltrim(carno) from order_car where orderid=b.orderid for xml path('')),1,1,'')
from
  [order] a
join
  order_car b
on
  a.orderid=b.orderid
group by
  b.orderid,
  a.ordertype


Ïà¹ØÎĵµ£º

SQL Server ÒÆÖ²µ½Oralce ÏîĿʵս

ÏîÄ¿±³¾°
         ÒÆÖ²Ò»¸öÏÖÓÐϵͳµ½Oracle¡£Ô­ÏµÍ³»ùÓÚ.Net Framework 1.1, SQL Server 2000Êý¾Ý¿â£¬Êý¾Ý²Ù×÷»ù±¾È«²¿Ê¹ÓÃStore Procedure£¬×ÜÊýÓâǧ£¬Òò´Ë×ÜÌåÉæ¼°µÄPL SQL ¿ª·¢Á¿±È½Ï´ó¡£
 
         ÓÅÏȼ¶¸ß£¬¿ª·¢Ê±³Ì¶Ì£ ......

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


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

SQL 2005 ¶Ôxml ÎļþÓë xmlÊý¾ÝµÄ²Ù×÷

 ÓÉÓÚÊý¾Ý¿â¶ÔxmlÊý¾ÝÖ±½Ó´¦ÀíÓкܶàÓÅÊÆ£¬05Ò²¶ÔÕâ·½Ãæ¼ÓÇ¿Á˹¦ÄÜ¡£
        µ«Õâ·½Ãæ×ÊÁÏÉÙ£¬ËùÒÔ×Ô¼º×öÁËһЩ×ܽᣬϣÍû»á¸ø´ó¼Ò´øÀ´°ïÖú
        --charry0110(Ïþ·ç²ÐÔÂ)
         --×÷Õߣº³Â ......

MS Sql ServerÊý¾Ý¿â·ÖÇø

ʲôÊÇÊý¾Ý¿â·ÖÇø£¿
Êý¾Ý¿â·ÖÇøÊÇÒ»ÖÖ¶Ô±íµÄºáÏò·Ö¸î£¬Sql server 2005ÆóÒµ°æºÍÖ®ºóµÄSql server°æ±¾²ÅÌṩÕâÖÖ¼¼Êõ£¬ÕâÖÖ¶Ô±íµÄºáÏò·Ö¸î²»Í¬ÓÚ2000Öеıí·Ö¸î£¬Ëü¶Ô·ÃÎÊÓû§ÊÇ͸Ã÷µÄ£¬Óû§²¢²»»á¸Ð¾õµÄ±í±»ºáÏò·Ö¸îÁË¡££¨2000ÖеıíºáÏò·Ö¸îÊǽ¨n¸ö±íÀýÈ簴ʱ¼ä½¨±íÿÔÂÒ»¸ö±í£¬±íÃû²»Í¬£¬×îºóÐèÒª×öÒ»¸ö´óÊÓͼ£©
Ϊʲ ......

SQL Óαêѧϰ

    ÎÊÌâÃèÊö£ºÓÐÒÔÏÂ2ÕÅ±í£¬
      a_id                      a_name               ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ