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

dz̸»ùÓÚSQL Server ·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø

 ¼òµ¥Ì¸»ùÓÚSQL SERVER ·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø
×÷ÕߣºÖ£×ô
ÈÕÆÚ£º2006-9-30
Õë¶ÔÊý¾Ý¿âÊý¾ÝÔÚUI½çÃæÉϵķÖÒ³ÊÇÀÏÉú³£Ì¸µÄÎÊÌâÁË£¬ÍøÉϺÜÈÝÒ×ÕÒµ½¸÷Ö֓ͨÓô洢¹ý³Ì”´úÂ룬¶øÇÒÓÐЩ»¹¶¨ÖƲéѯÌõ¼þ£¬¿´ÉÏȥʹÓúܷ½±ã¡£±ÊÕß´òËãͨ¹ý±¾ÎÄÒ²À´¼òµ¥Ì¸Ò»Ï»ùÓÚSQL SERVER 2000µÄ·ÖÒ³´æ´¢¹ý³Ì£¬Í¬Ê±Ì¸Ì¸SQL SERVER 2005Ï·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø¡£
ÔÚ½øÐлùÓÚUIÏÔʾµÄÊý¾Ý·Öҳʱ£¬³£¼ûµÄÊý¾ÝÌáÈ¡·½Ê½Ö÷ÒªÓÐÁ½ÖÖ¡£µÚÒ»ÖÖÊÇ´ÓÊý¾Ý¿âÌáÈ¡ËùÓÐÊý¾ÝÈ»ºóÔÚϵͳӦÓóÌÐò²ã½øÐÐÊý¾Ý·ÖÒ³£¬ÏÔʾµ±Ç°Ò³Êý¾Ý¡£µÚ¶þÖÖ·ÖÒ³·½Ê½Îª´ÓÊý¾Ý¿âÈ¡³öÐèÒªÏÔʾµÄÒ»Ò³Êý¾ÝÏÔʾÔÚUI½çÃæÉÏ¡£
ÒÔÏÂÊDZÊÕ߶ÔÁ½ÖÖʵÏÖ·½Ê½Ëù×öµÄÓÅȱµã±È½Ï£¬Õë¶ÔÓ¦ÓóÌÐò±àд£¬±ÊÕßÒÔ.NET¼¼Êõƽ̨ΪÀý¡£
Àà±ð
 SQLÓï¾ä
 ´úÂë±àд
 Éè¼Æʱ
 ÐÔÄÜ
 
µÚÒ»ÖÖ
 Óï¾ä¼òµ¥£¬¼æÈÝÐÔºÃ
 ºÜÉÙ
 ÍêÈ«Ö§³Ö
 Êý¾ÝÔ½´óÐÔÄÜÔ½²î
 
µÚ¶þÖÖ
 ¿´¾ßÌåÇé¿ö
 ½Ï¶à
 ²¿·ÖÖ§³Ö
 Á¼ºÃ£¬¸úSQLÓï¾äÓйØ
 
 
¶ÔÓÚµÚÒ»ÖÖÇé¿ö±¾ÎIJ»´òËã¾ÙÀý£¬µÚ¶þÖÖʵÏÖ·½Ê½±ÊÕßÖ»ÒÔÁ½´ÎTOP·½Ê½À´½øÐÐÌÖÂÛ¡£
ÔÚ±àд¾ßÌåSQLÓï¾ä֮ǰ£¬¶¨ÒåÒÔÏÂÊý¾Ý±í¡£
Êý¾Ý±íÃû³ÆΪ£ºProduction.Product¡£ProductionΪSQL SERVER 2005ÖиĽøºóµÄÊý¾Ý±í¼Ü¹¹£¬¶Ô¾ÙÀý²»Ôì³ÉÓ°Ïì¡£
°üº¬µÄ×Ö¶ÎΪ£º
ÁÐÃû
 Êý¾ÝÀàÐÍ
 ÔÊÐí¿Õ
 ËµÃ÷
 
ProductID
 Int
 
 ²úÆ·ID£¬PK¡£
 
Name
 Nvarchar(50)
 
 ²úÆ·Ãû³Æ¡£
 
²»ÄÑ·¢ÏÖÒÔÉϱí½á¹¹À´×ÔSQL SERVER 2005 ÑùÀýÊý¾Ý¿âAdventureWorksµÄProduction.Product±í£¬²¢ÇÒֻȡÆäÖÐÁ½¸ö×ֶΡ£ 
·ÖÒ³Ïà¹ØÔªËØ£º
PageIndex – Ò³ÃæË÷Òý¼ÆÊý£¬¼ÆÊý0ΪµÚÒ»Ò³¡£
PageSize – ÿ¸öÒ³ÃæÏÔʾ´óС¡£
RecordCount – ×ܼǼÊý¡£
PageCount – Ò³Êý¡£
¶ÔÓÚºóÁ½¸ö²ÎÊý£¬±ÊÕßÔÚ´æ´¢¹ý³ÌÖÐÒÔÊä³ö²ÎÊýÌṩ¡£
 
1£®SQL SERVER 2000ÖеÄTOP·ÖÒ³
CREATE PROCEDURE [Zhzuo_GetItemsPage]
    @PageIndex INT, /*@PageIndex´Ó¼ÆÊý,0ΪµÚÒ»Ò³*/
    @PageSize  INT, /*Ò³Ãæ´óС*/
    @RecordCount INT OUT, /*×ܼǼÊý*/
    @PageCount INT OUT /*Ò³Êý*/
AS
/*»ñÈ¡¼Ç¼Êý*/
SELECT @RecordCount = COUNT(*) from Production.Product


Ïà¹ØÎĵµ£º

²é¿´sql server 2000µÄ°æ±¾µÄÈýÖÖ·½·¨

·½·¨Ò»£º
´ò¿ªÆóÒµ¹ÜÀíÆ÷£­>SQL SERVRE ×飭>(local)window NT ->ÊôÐÔ
²úÆ·:ÓÐpersonalµÄÊǸöÈË°æµÄ£¬ÓÐEnterpriseµÄÊÇÆóÒµ°æµÄ
²úÆ·°æ±¾£º8.00.2039(sp4);8.00.760(sp3)
·½·¨¶þ£º
µÚÒ»²½£ºÔÚ²éѯ·ÖÎöÆ÷
select @@version
print @@version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 ......

sql2005 µ¥Óû§¸ÄΪ¶àÓû§sqlÓï¾ä

 USE master
GO
DECLARE @SQL VARCHAR(MAX);
SET @SQL=''
SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)
from master..sysprocesses
WHERE dbid=DB_ID('hotel');
EXEC(@SQL);
GO
ALTER DATABASE hotel SET MULTI_USER ......

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

 ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ