Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

ÓÃADO¹ÜÀíSQL SERVER £¡

      ÔÚÈí¼þ¿ª·¢ÖУ¬³£³£ÐèҪΪ³ÌÐò½¨Á¢Sql ServerÊý¾Ý¿âµÄÔËÐл·¾³¡£Íê³ÉÈçÔÚSQL ServerÊý¾Ý¿âÖн¨Á¢É豸£¬½¨Á¢Êý¾Ý¿â£¬½¨Á¢±í¸ñ£¬·ÖÅäȨÏ޵ȹ¦ÄÜ£¬ÈçºÎ·½±ãµÄ½¨Á¢Ó¦ÓóÌÐòËùÐèSql Server»·¾³µÄÊý¾Ý¿â»·¾³£¬¶ø²»ÓÃÆô¶¯SQL Enterprise ManagerÄØ£¿
ÏÂÃæÀ´¿´£º 
¡¡¡¡Æô¶¯VB6.0£¬Ð½¨Ò»¸ö¹¤ ......

SQL Server 2005ÀûÓ÷ÖÇø¶Ôº£Á¿Êý¾ÝµÄ´¦Àí


³¬´óÐÍÊý¾Ý¿âµÄ´óС³£³£´ïµ½Êý°ÙGB£¬ÓÐʱÉõÖÁÒªÓÃTBÀ´¼ÆËã¡£¶øµ¥±íµÄÊý¾ÝÁ¿ÍùÍù»á´ïµ½ÉÏÒڵļǼ£¬²¢ÇҼǼÊý»áËæ×Åʱ¼ä¶øÔö³¤¡£Õâ²»µ«Ó°Ïì×ÅÊý¾Ý¿âµÄÔËÐÐЧÂÊ£¬Ò²Ôö´óÊý¾Ý¿âµÄά»¤ÄѶȡ£³ýÁ˱íµÄÊý¾ÝÁ¿Í⣬¶Ô±í²»Í¬µÄ·ÃÎÊģʽҲ¿ÉÄÜ»áÓ°ÏìÐÔÄܺͿÉÓÃÐÔ¡£ÕâЩÎÊÌâ¶¼¿ÉÒÔͨ¹ý¶Ô´ó±í½øÐкÏÀí·ÖÇøµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£µ±±íºÍË÷Òý ......

jspÖзÀÖ¹sql×¢ÈëµÄһЩ»ù±¾Ô¤·À´ëÊ©

 Ò»¡¢É¶ÊÇsql×¢Èë
     Ëùνsql×¢Èë¼òµ¥Ëµ¾ÍÊDZ»ÈË×êÁËSQLµÄ¿Õ×ÓÏÂÃæ¾Ù¸ö×î¼òµ¥µÄÀý×Ó¡£
     sql Ϊ£º"select * from users where username='"+userName+"' and password='"+password+"' "
     1¡¢¹¥»÷ÕßÖ»ÒªÔÚ´«ÈëµÄuserName¼ÓÉÏ'--ÉÏÃæµÄsql±ã½« ......

AMD ÈýºË´¦ÀíÆ÷°²×°SQL Server2005³ö´í´¦Àí½â¾ö·½°¸¡£

     ×î½üѧSQL Server2005£¬ÏÂÔØÁËSQL2005ÖÐÎÄ¿ª·¢°æ£¬µ«ÊÇͬѧÃǶ¼°²×°ÉÏÁË£¬Î¨¶ÀÎҵĻúÆ÷°²×°²»ÉÏ¡£
     ÿ´Î°²×°DATABASEµÄʱºò¶¼ÌáʾÎÞ·¨Æô¶¯sqlservr.exe·þÎñÎÞ·¨Æô¶¯£¬ÖØ×°ÏµÍ³Ò²²»ÐУ¬WINXP WIN 7ÏÂÃæ¶¼ÎÞ·¨°²×°£¬ÓÚÊÇÉÏÍø²éÁËÏ£¬Ô­À´SQL2005²»Ö§³Ö3ºË´¦ÀíÆ÷£¬Î¢ÈíÒ²×Ô ......

ÖÕ¼¶½â¾öSQL Server 2005 δÕý³£Ð¶ÔØ£¬ÖØÐ°²×°ÎÊÌâ

 ÔÚÐ¶ÔØVisual Studio 2008 ʱ£¬Ìí¼Ó/ɾ³ý³ÌÐò ÀïÃæÓÐÐí¶àµÄ°²×°Îļþ£¬´ËʱÈç¹ûûÓÐÏÈÐ¶ÔØSQL Server 2005 £¬
¶øÏÈÐ¶ÔØ.Net Framework£¨Ìáʾ£ºÐ¶ÔØ.net FrameworkµÄµÃ°²°æ±¾´Ó¸ßµ½µÍµÄ˳Ðò£©£¬
ÕâʱSQL Server 2005¾ÍÎÞ·¨Ð¶ÔØ,ɾ³ýProgram files ÏÂÃæµÄ Microsoft SQL Server Îļþ¼ÐҲûÓÐ×÷Óá£
ÖØÐ°²×°ÌáʾÊý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ