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

MSSQLÊý¾Ý¿â±¸·Ý

1
¡¢
MSSQL
Êý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý¼Æ»®
 
ͨ¹ýÆóÒµ¹ÜÀíÆ÷
ÉèÖÃÊý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý¼Æ»®¡£
1
¡¢´ò¿ªÆóÒµ¹Ü
ÀíÆ÷£¬Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷
2
¡¢È»ºóµãÉÏÃæ
²Ëµ¥ÖеŤ¾ß
-->
Ñ¡ÔñÊý¾Ý¿âά»¤¼Æ»®Æ÷
3
¡¢ÏÂÒ»²½Ñ¡ÔñÒª½øÐÐ×Ô¶¯±¸·ÝµÄÊý¾Ý
-->
ÏÂÒ»²½¸üÐÂÊý¾ÝÓÅ»¯ÐÅÏ¢£¬ÕâÀïÒ»°ã²»ÓÃ×öÑ¡Ôñ
-->
ÏÂÒ»²½¼ì²éÊý¾ÝÍêÕûÐÔ£¬Ò²Ò»°ã²»Ñ¡Ôñ
4
¡¢ÏÂÒ»²½Ö¸¶¨Êý¾Ý¿âά»¤¼Æ»®£¬Ä¬ÈϵÄÊÇ
1
Öܱ¸·ÝÒ»´Î£¬µã»÷¸ü¸ÄÑ¡Ôñ±¸·ÝµÄÈÕÆÚ¼°Ê±¼äµã
È·¶¨
,
5
¡¢ÏÂÒ»²½Ö¸¶¨
±¸·ÝµÄ´ÅÅÌĿ¼£¬Ñ¡ÔñÖ¸¶¨Ä¿Â¼£¬È»ºóÑ¡Ôñɾ³ýÔçÓÚ¶àÉÙÌìǰµÄ±¸·Ý£¬Ñ¡ÔñÒ»¸öÐÇÆÚɾ³ýÒ»´Î±¸·Ý
,
¾ßÌ屸·Ý¿´ÄãµÄÒªÇ󣬱¸·ÝÎļþÀ©Õ¹ÃûĬÈϵÄÊÇ
BAK
6
¡¢ÏÂÒ»²½Ö¸¶¨ÊÂÎñÈÕÖ¾±¸·Ý¼Æ»®£¬¿´ÄãµÄÐèÒª×öÑ¡Ôñ
-->
ÏÂÒ»²½ÒªÉú³ÉµÄ±¨±í£¬Ò»°ã²»×öÑ¡Ôñ
-->
ÏÂÒ»²½Î¬»¤¼Æ»®ÀúÊ·¼Ç¼£¬×îºÃÓÃĬÈϵÄÑ¡Ïî
-->
ÏÂÒ»²½Íê³É
7
¡¢Íê³ÉºóϵͳºÜ¿ÉÄÜ»áÌáʾ
Sql
Server Agent
·þÎñδÆô¶¯£¬ÏȵãÈ·¶¨Íê³É¼Æ»®É趨£¬È»ºóÕÒµ½×ÀÃæ×îÓÒ±ß״̬À¸ÖеÄ
SQL
ÂÌɫͼ±ê£¬Ë«»÷µã¿ª£¬ÔÚ·þÎñÖÐÑ¡Ôñ
Sql
Server Agent
£¬È»ºóµã»÷ÔËÐмýÍ·£¬Ñ¡ÉÏÏ·½µÄµ±Æô¶¯
OS
ʱ×Ô¶¯Æô¶¯·þÎñ
8
¡¢¿ÉÒÔÉèÖÃÆô¶¯Æô¶¯
sql
server Agent:
ÔËÐÐ
Services.msc
£¬ÉèÖÃ
sqlserverAgent
Ϊ×Ô¶¯Æô¶¯¡£
2
¡¢
/*--
Êý¾Ý¿â
 

ÍêÈ«
+
ÔöÁ¿
(
²îÒì
)
±¸·Ý
/
»Ö¸´
 

ʾÀý
--*/
 
 
--
Çå³ý»·¾³
 
  exec   master..xp_cmdshell   'del  
c:\test.bak'  
  if   exists(select   *   from  
master..sysdatabases   where   name='test')  
  drop   database  
test  
  go  
   
  --
´´½¨Êý¾Ý¿â
 
  create   database   test  
  go  
 
 
  --
´ò¿ª´´½¨µÄÊý¾Ý
 

  use   test  
  go  
   
  --
´´½¨²âÊÔ±í
 
  create   table   t(a   int)  
   
 
--
Çл»»Ø
master
Êý¾Ý¿â
 
  use   master  
  go  
   
 
--
²åÈëÊý¾Ý
1  


Ïà¹ØÎĵµ£º

MSSQL ½øÖÆ×ª»»

-- ÈÎÒâ½øÖÆ×ª»»Îª10½øÖÆ
-- Àý 0FA ת»»Îª 16½øÖÆ select dbo.f_BinaryToInt('0123456789ABCDEF', '0FA')
CREATE   function   dbo.f_BinaryToInt(@BinaryFormate varchar(100), @num   varchar(200))  
--@BinaryFormate Ϊ×Ô¶¨ÒåµÄ½øÖƸñʽ
--@num ΪҪת»»³É10½øÖƵÄ×Ô¶¨ ......

MSSQLµÄһЩÓ÷¨¼¯ºÏ

ÔÚselect語¾äÀïÃæ¿ÉÒÔʹÓÃcase來對ij個colmunµÄÖµ進ÐзÖ別處Àí£¬±ÈÈç
select case color
when 1 then 'red'
when 2 then 'green'
when 3 then 'blue'
else 'black'
end as 'colorName',
foodName from foods
Èç¹ûʹÓÃÁËleft joinµÄ時ºò£¬Ä³個columnµÄn ......

ASP²ÉÓÃODBCÊý¾ÝÔ´Á¬½ÓMSSQLÊý¾Ý¿âÏêϸ˵Ã÷¡¾ÊµÓá¿

ODBCÊý¾ÝÔ´¿É·ÖΪ“ϵͳÐÍ”ºÍ“ÎļþÐÍ”£¬ËûÃǵÄÇø±ðÔÚÓړϵͳÐÍ”ÊÇÁ¬½ÓÊý¾Ý¿âµÄÐÅÏ¢½¨Á¢Ôړϵͳע²á±í”À“ÎļþÐÍ”ÔòÊÇÒÔdsnÎļþÐÎʽ´æ´¢ÔÚODBCÔ´µÄĿ¼ÏÂÃæ
Ò»¡¢½¨Á¢ODBCÊý¾ÝÔ´µÄ·½·¨£º
¿ØÖÆÃæ°å - ¹ÜÀí¹¤¾ß - Êý¾ÝÔ´£¨ODBC£©
´ò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¬È»ºóÒ ......

MsSql ²é¿´ÐÅÏ¢ºÃÓï¾ä

set statistics profile on
set statistics io on
set statistics time on
select top 1 * from et_order order by pkid desc
½á¹ûÈçÏ£º
SQL Server ·ÖÎöºÍ±àÒëʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Se ......

Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë

/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*PLU ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ