MSSQL ÓαêʹÓÃ
תÔØ http://www.jb51.net/article/17875.htm
MS-SQLÓαêµÄʹÓü°Àí½â windows»òDOSµÄ“¹â±ê”²»Í¬£¬MS-SQLµÄÓαêÊÇÒ»ÖÖÁÙʱµÄÊý¾Ý¿â¶ÔÏ󣬼ȶԿÉÓÃÀ´Ðýת´¢´æÔÚϵͳÓÀ¾Ã±íÖеÄÊý¾ÝÐеĸ±±¾£¬Ò²¿ÉÒÔÖ¸Ïò´¢´æÔÚϵͳÓÀ¾Ã±íÖеÄÊý¾ÝÐÐ
ÓαêΪÄúÌṩÁËÔÚÖðÐеĻù´¡É϶ø²»ÊÇÒ»´Î´¦ÀíÕû¸ö½á¹û¼¯Îª»ù´¡µÄ²Ù×÷±íÖÐÊý¾ÝµÄ·½·¨¡£
1£®ÈçºÎʹÓÃÓαê
1£©¶¨ÒåÓαêÓï¾ä Declare <ÓαêÃû> Cursor For
2£©´´½¨ÓαêÓï¾ä Open <ÓαêÃû>
3£©ÌáÈ¡ÓαêÁÐÖµ¡¢Òƶ¯¼Ç¼ָÕë Fetch <ÁÐÃûÁбí> from <ÓαêÃû> [Into <±äÁ¿Áбí>]
4£©Ê¹ÓÃ@@Fetch_StatusÀûÓÃWhileÑ»·´¦ÀíÓαêÖеÄÐÐ
5£©É¾³ýÓα겢ÊÍ·ÅÓï¾ä Close <ÓαêÃû>/Deallocate <ÓαêÃû>
6£©ÓαêÓ¦ÓÃʵÀý
--¶¨ÒåÓαê
Declare cur_Depart Cursor
For Select cDeptID,cDeptName from Department into @DeptID,@DeptName
--´´½¨Óαê
Open cur_Depart
--Òƶ¯»òÌáÈ¡ÁÐÖµ
Fetch from cur_Depart into @DeptID,@DeptName
--ÀûÓÃÑ»·´¦ÀíÓαêÖеÄÁÐÖµ
While @@Fetch_Status=0
Begin
Print @DeptID,@DeptName
Fetch from cur_Depart into @DeptID,@DeptName
End
--¹Ø±Õ/ÊÍ·ÅÓαê
Close cur_Depart
Deallocate cur_Depart
2£®Óï¾äµÄÏêϸ¼°×¢Òâ
1£©¶¨ÒåÓαêÓï¾ä
Declare <ÓαêÃû> [Insensitive] [Scroll] Cursor
For <Select Óï¾ä> [FOR {Read Only | Update [ OF <ÁÐÃûÁбí>]}]
Insensitive DBMS´´½¨²éѯ½á¹û¼¯Êý¾ÝµÄÁÙʱ¸±±¾£¨¶ø²»ÊÇʹÓÃÖ±½ÓÒýÓÃÊý¾Ý¿â±íÖеÄÕæʵÊý¾ÝÐÐÖеÄÁУ©¡£ÓαêÊÇRead Only£¬Ò²¾ÍÊÇ˵²»ÄÜÐÞ¸ÄÆäÄÚÈÝ»òµ×²ã±íµÄÄÚÈÝ£»
Scroll Ö¸¶¨ÓαêÖ§³Öͨ¹ýʹÓÃÈÎÒâFetch Ñ¡ÏFirst Last Prior Next Relative Absolute£©Ñ¡È¡ËüµÄÈÎÒâÐÐ×÷Ϊµ±Ç°ÐС£Èç¹û´ËÏîÊ¡ÂÔ£¬ÔòÓα꽫ֻ֧³ÖÏòÏÂÒƶ¯µ¥ÐУ¨¼´Ö»Ö§³ÖÓαêµÄFetch Next£©£»
SelectÓï¾ä ¶¨ÒåÓαê½á¹û¼¯µÄ±ê×¼ SELECT Óï¾ä¡£ÔÚÓαêÉùÃ÷µÄ <SelectÓï¾ä>ÄÚ²»ÔÊÐíʹÓùؼü×Ö COMPUTE¡¢COMPUTE BY¡¢FOR BROWSE ºÍ INTO£»
Read Only ·ÀֹʹÓÃÓαêµÄÓû§Í¨¹ý¸üÐÂÊý¾Ý»òɾ³ýÐиıäÓαêµÄÄÚÈÝ£»
Update ´´½¨¿É¸üÐÂÓαêÇÒÁгöÖµÄܱ»¸üеÄÓαêÁС£Èç¹û×Ó¾äÖÐÁÐÈëÁËÈÎÒâÁУ¬ÔòÖ»Óб»ÁÐÈëµÄÁвÅÄܱ»¸üС£Èç¹ûDeclare CursorÓï¾äÖÐÖ»Ö¸¶¨µÄUPDATE£¨Ã»ÓÐÁÐÃûÁÐ±í£©£¬ÔòÓα꽫ÔÊÐí¸üÐÂËüµÄÈκλòË
Ïà¹ØÎĵµ£º
½ñÌìÔÚÁÄÌìϵͳÖÐÐèҪϵͳִÐÐÒ»¸ö¶à²ãǶÌײéѯ¡£
Ò»¿ªÊ¼Óï¾äÈçÏÂ×ܳöÏÖ´íÎó£ºÔÀ´ÊÇÔÚ]='123') ºóÎÒ¶à¼ÓÁËÒ»¸ö as tb1
¸ÄΪÈçϺó£¬ÕýÈ·ÔËÐС£
select * from ( select top(10) * from ( select top(100) * from (select [chatcontent].[senderid],[chatcontent].[id] ,[chatcontent].[toid] ,[chatc ......
SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌṩµÄÊý¾ÝÀàÐ͵ıðÃû¡£ÓйØÓû§¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼û sp_addtype ºÍ´´½¨Óû§¶¨ÒåµÄÊý¾ÝÀàÐÍ¡£
µ±Á½¸ö¾ßÓв»Í¬Êý¾ÝÀàÐÍ¡¢ÅÅÐò¹æÔò¡¢¾«¶È¡¢Ð¡ÊýλÊý»ò³ ......
selectÓï¾äÇ°¼Ó£º
declare @d datetime
set @d=getdate()
²¢ÔÚselectÓï¾äºó¼Ó£º
select [Óï¾äÖ´Ðл¨·Ñʱ¼ä(ºÁÃë)]=datediff(ms,@d,getdate())
ת×Ô£º¶¯Ì¬ÍøÖÆ×÷Ö¸ÄÏ www.knowsky.com
ÕâÊǼòÒ׵IJ鿴ִÐÐʱ¼äµÄ·½·¨¡£
===========================================£¨Ò»ÏÂÄÚÈÝת×Ô£º£Ã£Ó£Ä£Î£©
MSSQL ServerÖÐͨ¹ý²é ......
How is MSSQL using memory?
http://www.sqlhacks.com/Administration/Memory-Usage
Memory is one the most important factor affecting MSSQL performance.
As an administrator, you should be monitoring the memory
regularly. When Microsoft SQL Server runs out of memory, it will use
virtual memory: ie: ......
ÈçºÎ´´½¨Á´½Ó·þÎñÆ÷
IF EXISTS (SELECT srv.name from sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Á´½Ó·þÎñÆ÷Ãû')
EXEC master.dbo.sp_dropserver @server=N'Á´½Ó·þÎñÆ÷Ãû'', @droplogins='droplogins'
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'Á´½Ó·þÎñÆ÷Ãû'', @srvproduct= ......