Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý

1.     µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
       select getdate()  
2. dateadd     ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
      ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
      select dat ......

×î¼òµ¥µÄSQL ServerÊý¾Ý¿â´æ´¢¹ý³Ì·ÖÒ³


×î¼òµ¥µÄSQL ServerÊý¾Ý¿â´æ´¢¹ý³Ì·ÖÒ³
 
·¢²¼Ê±¼ä£º2008.07.02 05:11     À´Ô´£ºÈüµÏÍø    ×÷ÕߣºAlizze
¡¾ÈüµÏÍø£­IT¼¼Êõ±¨µÀ¡¿×î¼òµ¥µÄSQL ServerÊý¾Ý¿â´æ´¢¹ý³Ì·ÖÒ³:
1.Ö»ÐèÒªÌṩSqlÓï¾äºÍÿҳµÄ¼Ç¼Êý,Ò³Êý¾Í¿ÉÒÔÁË
2,Ëٶȳ¬¿ìÓ´,100W¼Ç¼1~3Ãë¾Í·Ö³öÀ´ÁË
......

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

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

Sql Server ÈÕÆÚ¸ñʽ»¯

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......

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


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