Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ö´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

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 µÄÊý¾Ý»¹Ô­

»¹Ô­µÄ±¨´íÐÅÏ¢:

System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)

Çë¸÷λ¸ßÊÖ°ïæ½â¾ö

»¹Ô­µÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ