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 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 ......
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 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾ ......