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

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

    ÏÔʾָ¶¨±í¡¢ÊÓͼ¡¢²éѯ½á¹ûµÄµÚXÒ³
    ¶ÔÓÚ±íÖÐÖ÷¼ü»ò±êʶÁеÄÇé¿ö,Ö±½Ó´ÓÔ­±íÈ¡Êý²éѯ£¬ÆäËüÇé¿öʹÓÃÁÙʱ±íµÄ·½·¨
    Èç¹ûÊÓͼ»ò²éѯ½á¹ûÖÐÓÐÖ÷¼ü,²»ÍƼö´Ë·½·¨
    Èç¹ûʹÓòéѯÓï¾ä,¶øÇÒ²éѯÓï¾äʹÓÃÁËorder by,Ôò²éѯÓï¾ä±ØÐë°üº¬top Óï¾ä

--×Þ½¨ 2003.09(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)--*/

/*--µ÷ÓÃʾÀý
    exec p_show 'µØÇø×ÊÁÏ'

    exec p_show 'select top 100 percent * from µØÇø×ÊÁÏ order by µØÇøÃû³Æ',5,3,'µØÇø±àºÅ,µØÇøÃû³Æ,Öú¼ÇÂë'
--*/
alter Proc p_show
@QueryStr nvarchar(4000),    --±íÃû¡¢ÊÓͼÃû¡¢²éѯÓï¾ä
@PageSize int=10,            --ÿҳµÄ´óС(ÐÐÊý)
@PageCurrent int=1,            --ÒªÏÔʾµÄÒ³
@FdShow nvarchar (4000)='',    --ÒªÏÔʾµÄ×Ö¶ÎÁбí,Èç¹û²éѯ½á¹û²»ÐèÒª±êʶ×Ö¶Î,ÐèÒªÖ¸¶¨´ËÖµ,ÇÒ²»°üº¬±êʶ×Ö¶Î
@FdOrder nvarchar (1000)=''    --ÅÅÐò×Ö¶ÎÁбí
as
set nocount on
declare @FdName nvarchar(250)    --±íÖеÄÖ÷¼ü»ò±í¡¢ÁÙʱ±íÖеıêʶÁÐÃû
    ,@Id1 varchar(20),@Id2 varchar(20)    --¿ªÊ¼ºÍ½áÊøµÄ¼Ç¼ºÅ


Ïà¹ØÎÊ´ð£º

sqlserver´æ´¢¹ý³Ì¸Äoracle

sqlserver´æ´¢¹ý³Ì¸Äoracle
Ë­»á°¡¡£¡£¡£°ïæ¸Ä¸Ä··


SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER    PROCEDURE tp_Fetch_List( 
  ......

SqlServer »ù´¡ÎÊÌâ

Ô­Êý¾Ý£º



¾­¹ý´ËsqlÓï¾ä²éѯ³öÀ´µÄ½á¹ûÊÇ£º
SQL code:
select Code, Name=stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')
from C




¼ÓÉÏG ......

sqlserver 2005 ¹ØÓÚÈÕÆÚ¸ñʽ

±ÈÈç ´«½øÀ´µÄ×Ö·û´®ÊÇ ¡®12/sep/2009 12£º52£º20¡¯ Ö±½ÓÓÃcast»á±¨´í¡£
¶øÇÒÖмäµÄÔ·ÝÒ²²»¹Ì¶¨ ¡£Ôõôת»»³ÉÈÕÆÚÐ͵ÄÄØ
ÓÃÒ»¸ö±í¼Ç¼1-12Ô·ݣ¡

Ö±½Óת»»ÊDz»ÐÐÁË ²ð·Ö ³öÔÂÀ´ÅжÏÁË

¡®12/sep/2009 12£º ......

ÇóÒ»»îÔ¾µÄsqlserverµÄqqȺ

ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..

ÕâÀï¾ÍÊÇ

ÕâÀï±ÈQQȺÀïÈÈÄÖ

ÎÒÒ²ÏëÕÒÕâô¸öȺ

.

SQL code:
¡£¡£¡£¡£¡£

¡£

ºÇºÇ

ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ


ͬÒâ

發錯° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ