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

ÅúÁ¿Æô¶¯¹Ø±Õ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±à³Ì¹æ·¶µÄÎĵµ

Ò»¡¢sqlÊéд¹æ·¶£º
  1¡¢sqlÓï¾äµÄËùÓбíÃû¡¢×Ö¶ÎÃûÈ«²¿Ð¡Ð´£¬ÏµÍ³±£Áô×Ö¡¢ÄÚÖú¯ÊýÃû¡¢sql±£Áô×Ö´óд¡£
   
  2¡¢Á¬½Ó·ûor¡¢in¡¢and¡¢ÒÔ¼°£½¡¢<=¡¢>=µÈǰºó¼ÓÉÏÒ»¸ö¿Õ¸ñ¡£
   
  3¡¢¶Ô½ÏΪ¸´ÔÓµÄsqlÓï¾ä¼ÓÉÏ×¢ÊÍ£¬ËµÃ÷Ëã·¨¡¢¹¦ÄÜ¡£
   
&nb ......

SQL SERVER 2000 °²×°Ìáʾ"Ò»°ãÐÔÍøÂç´íÎó"

 ½ñÌì°²×°SQL SERVER 2000 ¸öÈ˰棬°²×°×îºóµ¯³ö´íÎó¶Ô»°¿ò£º
“°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\windows\sqlstp.log”£¬´Ó¶øÎÞ·¨°²×°¡£
µ½¾ßÌåµÄĿ¼²é¿´ÏÔʾ"Ò»°ãÐÔÍøÂç´íÎó"£¬ÔÚÍøÉÏËÑË÷ÎÊÌâÔ­Òò¼°½â¾ö·½°¸ÈçÏ£º
´ËÎÊÌâÊôÓÚsql serverµÄbug, GetComputerName ÓÃÓÚ»ñÈ¡±¾µØ¼ÆËã»úÃû¡£ ......

ÎÄ˼´´ÐµÄSQL±ÊÊÔÌâ


ÌâÄ¿£ºÓÐAºÍBÁ©¸ö±í£¬¶¼¶¨ÒåÏàͬµÄÖ÷¼ü£¬Ð´³öSQLÓï¾äÕÒ³öA±íÖÐÓжøB±íÖÐûÓеļǼ£¬È»ºó°ÑûÓеļǼ²åÈëµ½B±íÖС£
SQLÓï¾äÈçÏ£º
CREATE TABLE  A_MINUS_B  AS              ---´´½¨Ò»¸ö²î¼¯±íA_MINUS_B ,×¢ÒâSELECT Óï¾äÒ»¶¨ÒªA±íÔÚǰ¡ ......

SQLÊý¾ÝÀàÐÍÏê½â

(1)¶þ½øÖÆÊý¾ÝÀàÐÍ

¡¡¡¡¶þ½øÖÆÊý¾Ý°üÀ¨ Binary¡¢Varbinary ºÍ Image
¡¡¡¡Binary
Êý¾ÝÀàÐͼȿÉÒÔÊǹ̶¨³¤¶ÈµÄ(Binary),Ò²¿ÉÒÔÊDZ䳤¶ÈµÄ¡£
¡¡¡¡Binary[(n)] ÊÇ n λ¹Ì¶¨µÄ¶þ½øÖÆÊý¾Ý¡£ÆäÖУ¬n
µÄȡֵ·¶Î§ÊÇ´Ó 1 µ½ 8000¡£Æä´æ´¢ñ¿µÄ´óСÊÇ n + 4 ¸ö×Ö½Ú¡£
¡¡¡¡Varbinary[(n)] ÊÇ n
λ±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý¡£ÆäÖУ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ