ÅúÁ¿Æô¶¯¹Ø±ÕMS SQL 2005·þÎñBAT
µ±×°ÉÏÁËMSSQL2005ºó£¬ÄÚ´æµÄÕ¼Óûá±äµÃºÜ´ó¡£ËùÒÔÈç¹ûÓÃÒ»¸öÅúÁ¿´¦ÀíÀ´¿ªÆô»ò¹Ø±ÕMSSQL2005ËùÓеķþÎñ£¬Äǽ«»áÈÃÎÒÃǵĵçÄÔ¸üºÃʹÓ᣸ù¾Ý×Ô¼ºµÄ¾Ñ飬×ö³öÁËÏÂÃæÁ½¸öÅú´¦Àí£º
1¡¢¿ªÆô·þÎñ£º£¨¸´ÖƺáÏßµÄÄÚÈÝ£¬×¢Ò⣬·þÎñÆ÷ÕæÕýµÄÃû³ÆÄã¿ÉÒÔͨ¹ý“¿ªÊ¼--¡·¿Ø¼þÃæ°æ--¡·¹ÜÀí¹¤¾ß--¡··þÎñ--¡·ÕÒµ½ÏàÓ¦µÄ·þÎñÆ÷ÏÔʾÃû³ÆÈ»ºóµã»÷ÓÒ¼ü£¬¿ÉÒÔ¿´µ½³£¹æÀïÓÐÒ»¸ö‘·þÎñÆ÷Ãû³Æ’£¬ÄǸö²ÅÊÇ·þÎñµÄÕæÕýÃû³Æ”£©
---------------------------------------------------------------------------------------------------
@ECHO OFF
ECHO ÕýÔÚÆô¶¯MS Server 2005Ïà¹Ø·þÎñ£¬ÇëµÈ´ý ... ...
net start MSSQL$MSSQL
net start SQLAgent$MSSQL
net start MSOLAP$MSSQL
net start SQLBrowser
net start msftesql$MSSQL
net start ReportServer$MSSQL
net start MsDtsServer
echo MS Server 2005Òѳɹ¦Æô¶¯£¬Çë°´ÈÎÒâ¼üÍ˳ö... ...
echo. & pause
--------------------------------------------------------------------------------------------------
2¡¢¹Ø±Õ·þÎñ£º
--------------------------------------------------------------------------------------------------
@ECHO OFF
ECHO ÕýÔڹرÕMS Server 2005Ïà¹Ø·þÎñ£¬ÇëµÈ´ý ... ...
net stop MSSQL$MSSQL /y
net stop SQLAgent$MSSQL
net stop MSOLAP$MSSQL
net stop SQLBrowser
net stop msftesql$MSSQL
net stop ReportServer$MSSQL
net stop MsDtsServer
echo MS Server 2005Òѳɹ¦¹Ø±Õ£¬Çë°´ÈÎÒâ¼üÍ˳ö... ...
echo. & pause
--------------------------------------------------------------------------------------------------
ÎÒÕâÀïÊÇÓÃNET START ºÍNET STOPÀ´¿ª¹Ø·þÎñ£¬ÓÃSC START ºÍSC STOPÀ´ºÃÏñÔڹرշþÎñÆ÷ʱ²»ÄÜÈ«¹Ø¡£
Áíһƪ
2°²×°Íê±ÏSQL SERVER 2005ºó£¬»áĬÈÏ×Ô¶¯Æô¶¯SQL ServerµÈ¼¸¸ö·þÎñ£¬Õ⼸¸ö·þÎñ±È½ÏÕ¼ÓÃϵͳ×ÊÔ´¡£µ±²»ÔËÐÐSQL Serverʱ£¬×îºÃÍ£Ö¹ÕâЩ·þÎñ¡£Èç¹ûÒ»¸ö¸öµã»÷ÕâЩ·þÎñ£¬¹ýÓÚÂé·³ÁË£¬¿ÉÒÔÓÃÅú´¦ÀíÎļþÀ´Æô¶¯ºÍÍ£Ö¹¸ÃÀà·þÎñ¡£
Ê×ÏȽ«“¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->·þÎñ”ÀïÃæµÄSQL SERVER 2005Ïà¹ØµÄ·þÎñÆô¶¯ÀàÐÍÉèÖÃΪÊÖ¶¯£¨SQL Server¿ªÍ·µÄ·þÎñ£©£¬È»ºóн¨Á¢Ò
Ïà¹ØÎĵµ£º
Ò»¡¢sqlÊéд¹æ·¶£º
1¡¢sqlÓï¾äµÄËùÓбíÃû¡¢×Ö¶ÎÃûÈ«²¿Ð¡Ð´£¬ÏµÍ³±£Áô×Ö¡¢ÄÚÖú¯ÊýÃû¡¢sql±£Áô×Ö´óд¡£
2¡¢Á¬½Ó·ûor¡¢in¡¢and¡¢ÒÔ¼°£½¡¢<=¡¢>=µÈǰºó¼ÓÉÏÒ»¸ö¿Õ¸ñ¡£
3¡¢¶Ô½ÏΪ¸´ÔÓµÄsqlÓï¾ä¼ÓÉÏ×¢ÊÍ£¬ËµÃ÷Ëã·¨¡¢¹¦ÄÜ¡£
&nb ......
½ñÌì°²×°SQL SERVER 2000 ¸öÈ˰棬°²×°×îºóµ¯³ö´íÎó¶Ô»°¿ò£º
“°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\windows\sqlstp.log”£¬´Ó¶øÎÞ·¨°²×°¡£
µ½¾ßÌåµÄĿ¼²é¿´ÏÔʾ"Ò»°ãÐÔÍøÂç´íÎó"£¬ÔÚÍøÉÏËÑË÷ÎÊÌâÔÒò¼°½â¾ö·½°¸ÈçÏ£º
´ËÎÊÌâÊôÓÚsql serverµÄbug, GetComputerName ÓÃÓÚ»ñÈ¡±¾µØ¼ÆËã»úÃû¡£ ......
ÌâÄ¿£ºÓÐAºÍBÁ©¸ö±í£¬¶¼¶¨ÒåÏàͬµÄÖ÷¼ü£¬Ð´³öSQLÓï¾äÕÒ³öA±íÖÐÓжøB±íÖÐûÓеļǼ£¬È»ºó°ÑûÓеļǼ²åÈëµ½B±íÖС£
SQLÓï¾äÈçÏ£º
CREATE TABLE A_MINUS_B AS ---´´½¨Ò»¸ö²î¼¯±íA_MINUS_B ,×¢ÒâSELECT Óï¾äÒ»¶¨ÒªA±íÔÚǰ¡ ......
(1)¶þ½øÖÆÊý¾ÝÀàÐÍ
¡¡¡¡¶þ½øÖÆÊý¾Ý°üÀ¨ Binary¡¢Varbinary ºÍ Image
¡¡¡¡Binary
Êý¾ÝÀàÐͼȿÉÒÔÊǹ̶¨³¤¶ÈµÄ(Binary),Ò²¿ÉÒÔÊDZ䳤¶ÈµÄ¡£
¡¡¡¡Binary[(n)] ÊÇ n λ¹Ì¶¨µÄ¶þ½øÖÆÊý¾Ý¡£ÆäÖУ¬n
µÄȡֵ·¶Î§ÊÇ´Ó 1 µ½ 8000¡£Æä´æ´¢ñ¿µÄ´óСÊÇ n + 4 ¸ö×Ö½Ú¡£
¡¡¡¡Varbinary[(n)] ÊÇ n
λ±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý¡£ÆäÖУ ......