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

Ô¶³Ì±¸·ÝSQL Server 2005Êý¾Ý¿â

 ½ñÌìÖÕÓÚ°ÑÕâ¸öÎÊÌâ¸ø½â¾öÁË£º
²Î¿¼ÎÄÕ£ºhttp://blog.csdn.net/long2006sky/archive/2007/04/23/1576583.aspx
ʵÀý˵Ã÷£º
           »·¾³£ºwin2k+sqlserver 2K+²éѯ·ÖÎöÆ÷
           SQLSERVER·þÎñʵÀýÃû³Æ:mainserver
           ÐèÒª±¸·ÝµÄÊý¾Ý¿âÃû³Æ: msdb
           ±¾µØ»úÆ÷Ãû³Æ£¨Client¶Ë£©£ºdavid
           ±¾µØÓû§:zf ÃÜÂ룺123
           ±¾µØÓòÃû£ºdomain
           ±¾µØÌṩ±¸·ÝÐèÇóµÄÎļþ¼Ð:e:\test
  µÚÒ»²½: ½¨Á¢¹²ÏíÎļþ¼Ð
     ÔÚ³ÌÐò´úÂëÖе÷Ó㨻òÕßCMD´°¿Ú£©  net share test=e:\test
     »òÕßÓÃNetShareAddÕâ¸öAPI
     ¼òҪ˵Ã÷£º
            net share     : ÊÇWINDOWSÄÚ²¿µÄÍøÂçÃüÁî¡£
                            ×÷Ó㺽¨Á¢±¾µØµÄ¹²Ïí×ÊÔ´£¬ÏÔʾµ±Ç°¼ÆËã»úµÄ¹²Ïí×ÊÔ´ÐÅÏ¢¡£
                            Óï·¨£º²Î¼û net share /? 
  µÚ¶þ²½: ½¨Á¢¹²ÏíÐÅÓùØϵ
     master..xp_cmdshell 'net use  \\david\test
123 /user:domain\zf'
     ¼òҪ˵Ã÷£º
           1£ºxp_cmdshell £ºÊÇSQLSERVERµÄÀ©Õ¹´æ´¢¹ý³Ì¡£
                            ×÷Óã¬ÒÔ²Ù×÷ϵͳ
ÃüÁîÐнâÊÍÆ÷µÄ·½Ê½Ö´Ðиø¶¨µÄÃüÁî×Ö


Ïà¹ØÎĵµ£º

SQL SERVER ²é¿´CPUÀûÓÃÂÊ

 --²é¿´CPUÀûÓÃÂÊ
-- CREATE PROCEDURE sp_GetTop10_CPU () AS
BEGIN
  SET NOCOUNT ON
  DECLARE @cinterval char(8)
  DECLARE @interval int
  SET @cinterval = '00:00:10'
  CREATE TABLE #thread
  (
    RUN INT NOT NULL,
    SPI ......

Oracle SQLÓï¾ä

ORDER BY ÅÅÐò
 
ASC ÉýÐò(ĬÈÏ)
 DESC ½µÐò
 
select * from s_emp order by dept_id , salary desc
²¿ÃźÅÉýÐò£¬¹¤×ʽµÐò
¹Ø¼ü×ÖdistinctÒ²»á´¥·¢ÅÅÐò²Ù×÷¡£
 
select * from employee order by 1; //°´µÚÒ»×Ö¶ÎÅÅÐò
NULL±»ÈÏΪÎÞÇî´ó¡£order by ¿ÉÒÔ¸ú±ðÃû¡£
 
select table_name ......

SQL Server 2000µÄJDBCÁ¬½ÓÎÊÌâ½â¾ö·½·¨

 ¾­¹ýºÃ¼¸ÌìµÄ·ÜÕ½£¬JDBCÖÕÓڳɹ¦Á¬½ÓÁËSQL Server 2000£¬ÆÚ¼ä×ßÁ˲»ÉÙÍä·£¬ÔÚÕâÀï·ÖÏíÎÒµÄÒ»µã¾­Ñé
Ò»¡¢ÎҵĻ·¾³
   Windows XP+JDK6u15+Microsoft SQL Server 2000£¨SP4£©+JCreator
   ÎÒÏÈÔÚÍøÉÏÏÂÔØÊý¾Ý¿âÇý¶¯³ÌÐò£¬Ä¿Â¼ÏÂÓÐÈý¸ö°ümsbase.jar mssqlserver.jar msutil.jar
   1 ......

Sql Server·¢ÓʼþÅäÖÃ

¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾ­ÕýÈ·ÅäÖá£
    £¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
     ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ