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

SqlServerÆô¶¯²ÎÊý

SqlServerÆô¶¯²ÎÊý
1.Sqlservr.exeÔËÐвÎÊý¡£
SqlServerµÄÆô¶¯¿ÉÒÔΪWindows·þÎñ·½Ê½£¨Ä¬ÈÏ£©£¬Ò²¿ÉÒÔÒÔÓ¦ÓóÌÐò·½Ê½Æô¶¯¡£ÏÂÃæ½éÉÜsqlservr.exeÒÔÓ¦ÓóÌÐò·½Ê½Æô¶¯Ê±µÄ²ÎÊýÎÊÌâ¡£
sqlservrÓ¦ÓóÌÐòÓ÷¨£º
sqlservr[-sinstance_name][-c][-dmaster_path][-f]
[-eerror_log_path][-lmaster_log_path][-m]
[-n][-Ttrace#][-v][-x][-gnumber][-O][-ynumber]
-sinstance_name
Ö¸¶¨ÒªÁ¬½Óµ½µÄSQLServerʵÀý¡£Èç¹ûδָ¶¨ÃüÃûʵÀý£¬sqlservr½«Æô¶¯SQLServerĬÈÏʵÀý¡£ÖØÒªÆô¶¯SQLServerʵÀýʱ£¬±ØÐë´ÓʵÀýËùÔÚµÄÊʵ±Ä¿Â¼Ê¹ÓÃsqlservrÓ¦ÓóÌÐò¡£¶ÔÓÚĬÈÏʵÀý£¬´Ó\MSSQL\BinnĿ¼ÔËÐÐsqlservr¡£¶ÔÓÚÃüÃûʵÀý£¬ÔÚ\MSSQL$instance_name\BinnĿ¼ÔËÐÐsqlservr¡£
-c
±íʾÒÔ¶ÀÁ¢ÓÚWindowsNT·þÎñ¿ØÖƹÜÀíÆ÷µÄ·½Ê½Æô¶¯SQLServerʵÀý¡£µ±´ÓÃüÁîÌáʾ·ûÏÂÆô¶¯SQLServerʱ£¬¿ÉʹÓøÃÑ¡ÏîËõ¶ÌÆô¶¯SQLServerµÄʱ¼ä¡££¨×¢Ò⣺µ±Ê¹ÓøÃÑ¡Ïîʱ£¬ÎÞ·¨Í¨¹ýʹÓÃSQLServer·þÎñ¹ÜÀíÆ÷»ònetstopÃüÁîÍ£Ö¹SQLServer£¬¶øÇÒÈç¹ûÒÑ´ÓMicrosoftWindowsNT?ϵͳעÏú£¬ÔòSQLServer½«Í£Ö¹ÔËÐС££©-dmaster_pathÖ¸³ömasterÊý¾Ý¿âÎļþµÄÍêÈ«ºÏ·¨Â·¾¶¡£ÔÚ-dºÍmaster_pathÖ®¼äûÓпոñ¡£
-f
ÒÔ×îСÅäÖÃģʽÆô¶¯·þÎñÆ÷¡£È»ºó£¬ÏµÍ³¹ÜÀíÔ±¿É¶ÔÅäÖÃÑ¡ÏîÖØÐÂÅäÖã¨Ê¹ÓÃsp_configureϵͳ´æ´¢¹ý³Ì£©¡£
-eerror_log_path
±íʾ´íÎóÈÕÖ¾ÎļþµÄÍêÈ«ºÏ·¨Â·¾¶¡£Èç¹ûδָ¶¨Â·¾¶£¬ÔòĬÈÏʵÀýµÄĬÈÏλÖÃÊÇx:\ProgramFiles\MicrosoftSQLServer\MSSQL\Log\Errorlog£¬ÃüÃûʵÀýµÄĬÈÏλÖÃÊÇx:\ProgramFiles\MicrosoftSQLServer\MSSQL$instance_name\Log\Errorlog¡£ÔÚ-eºÍerror_log_pathÖ®¼äûÓпոñ¡£
-lmaster_log_path
ָʾmasterÊý¾Ý¿âÊÂÎñÈÕÖ¾ÎļþµÄÍêÈ«ºÏ·¨Â·¾¶¡£ÔÚ-lºÍmaster_log_pathÖ®¼äûÓпոñ¡£
-m
±íʾÔÚµ¥Óû§Ä£Ê½ÏÂÆô¶¯SQLServerʵÀý¡£Èç¹ûSQLServerÊÇÒÔµ¥Óû§Ä£Ê½Æô¶¯µÄ£¬ÔòÖ»ÄÜÁ¬½ÓÒ»¸öÓû§¡£CHECKPOINT»úÖÆ£¨ËüÈ·±£Íê³ÉµÄÊÂÎñ¶¨ÆÚ´Ó´ÅÅ̸ßËÙ»º´æдÈëÊý¾Ý¿âÉ豸ÖУ©½«²»Æô¶¯¡££¨Ò»°ãÇé¿öÏ£¬Èç¹ûÄúÓöµ½ÐèÒªÐÞ¸´µÄϵͳÊý¾Ý¿âÎÊÌâʱ£¬¿ÉʹÓôËÑ¡Ïî¡££©
-n
±íʾÄú²»ÏëʹÓÃWindowsNTÓ¦ÓóÌÐòÈÕÖ¾À´¼Ç¼SQLServerʼþ¡£Èç¹ûÓÃ-nÑ¡ÏîÆô¶¯SQLServerʵÀý£¬Ôò×îºÃҲʹÓÃ-eÑ¡Ï·ñÔò½«²»»á¼Ç¼SQLServerʼþ¡£
-Ttrace#
±íʾӦʹÓÃÖ¸¶¨µÄÓÐЧ¸ú×Ù±ê¼Ç(trace#)À´Æô¶¯SQLServerʵÀý¡£¸ú×Ù±êÖ¾ÓÃÀ´Æô¶¯¾ßÓзDZê×¼ÐÐΪµÄ·þÎñÆ÷¡£ÓйؿÉÓøú×Ù±ê¼Ç(trace#)µÄ¸ü¶àÐÅÏ¢£¬Çë²Î¼û¸ú×Ù±ê¼Ç¡£ÖØÒªµ±Ö¸


Ïà¹ØÎĵµ£º

sqlserver Êý¾Ý±¸·Ý»¹Ô­·½·¨

1¡¢²é¿´Ô­Êý¾Ý¿â±¸·ÝÇé¿ö£ºRESTORE FILELISTONLY from DISK = 'c:\NMGCNC-BABY_2009-4-1.dat' WITH NOUNLOAD, FILE = 1
2¡¢½øÐÐÊý¾Ý¿â»¹Ô­£º
restore database babyAndwed from DISK = 'c:\NMGCNC-BABY_2009-4-1.dat' with move 'babyAndwed_Data' to
'c:\NMGCNC-BABY_Data.MDF',move 'babyAndwed_Log' to 'c:\NMGCNC-B ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ 
S:select abs(-1) value
O:select abs(-1)  value from dual
2.È¡Õû(´ó) 
S:select ceiling(-1.001) value  
O:select ceil(-1.001)  value from dual
3.È¡Õû£¨Ð¡£© 
S:select floor(-1.001) value  
O:select floor(-1.001)  value from dual
4.È ......

sqlserver »ù´¡ÖªÊ¶´óÕûÀí

                              SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹û ......

sqlserver·ÖÒ³

ÏÖÔÚÒ»°ã³£ÓõÄÓÐÒÔÏÂ2ÖÖ·½·¨:
1. select top @pagesize * from table1 where id not in  (select top @pagesize*(@page-1) id  from table1 order by id) order by id
2. select *  from (select top @pagesize * from (select top @pagesize*@page * from table1 order by id) a order by id desc) b or ......

SQLSERVER¾Û¼¯Ë÷ÒýÓë·Ç¾Û¼¯Ë÷Òý£¨×ªÔØ£©

΢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)…… (Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹ ʵ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ