sql server2005Öµ±È½ÏÇó¾È¸÷λ¸ßÊÖ
ÔÚsql server2005ÖÐÔõô½øÐжàÖµÓë¶àÖµÖ®¼äµÄ±È½Ï£¿¿ÉÒԱȽÏÂð£¿
ÀýÈ磺
ÎÒÒªÖ¤Ã÷1£¬2£¬3£¬4£¬5£¨ÔÚ±íÖвéѯ³öµÄÖµ£©Óë3£¬2£¬6£¬5£¨×Ô¶¨Òå²ÎÊý£©Á½ÌõÊý¾ÝÖÐÓÐÏàͬµÄÖµ£¬²¢½«ÏàֵͬµÄÁеÄÏàÓ¦±íÐÅÏ¢ÓÃprint´òÓ¡³öÀ´
×¢Ò⣬²»Äܵ¥¸ö±È½Ï……
²»ÖªµÀ¿É²»¿É²éѯ³öÀ´£¬ Çë¸÷λ¸ßÊÖ°ï°ïæ……
лл£¡
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ÔÚ¼ÆËã»úÖÐÊý¾ÝÓÐÁ½ÖÖÌØÕ÷£ºÀàÐͺͳ¤¶È¡£ËùνÊý¾ÝÀàÐ;ÍÊÇÒÔÊý¾ÝµÄ±íÏÖ·½Ê½ºÍ´æ´¢·½Ê½À´»®·ÖµÄÊý¾ÝµÄÖÖÀà¡£
ÔÚSQL Server ÖÐÿ¸ö±äÁ¿¡¢²ÎÊý¡¢±í´ïʽµÈ¶¼ÓÐÊý¾ÝÀàÐÍ¡£ÏµÍ³ÌṩµÄÊý¾ÝÀàÐÍ·ÖΪ¼¸´óÀ࣬Èç±í4-2 Ëùʾ¡£
ÆäÖУ¬BIGINT¡¢ SQL_VARIANT ºÍTABLE ÊÇSQL Server 2000 ÖÐÐ ......
JAVA£×Ö·û´®¹ýÂËÀà
package cn.com.hbivt.util;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
/ ......
SQL SERVER ·þÎñ
SQL Server Analysis Services £ºÎªÉÌÒµÖÇÄÜÓ¦ÓóÌÐòÌṩÁª»ú·ÖÎö´¦Àí(OLAP)ºÍÊý¾ÝÍÚ¾ò¹¦ÄÜ(ºËÐÄ·þÎñ)¡£
SQL Server Browser£º½« SQL Server Á¬½ÓÐÅÏ¢Ìṩ¸ø¿Í»§¶Ë¼ÆËã»ú
SQL Server FullText Search£º¿ìËÙ´´½¨½á¹¹»¯ºÍ°ë½á¹¹»¯Êý¾ÝµÄÄÚÈݺÍÊôÐÔ
SQL Server VSS Writer£ºÌṩͨ¹ý Windows VSS »ù´¡½á¹¹ ......
package cn.com.hbivt.util;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
//¹ýÂËͨ¹ýÒ³Ãæ±íµ¥Ìá½» ......