Ô¶³Ì±¸·Ý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µÄÀ©Õ¹´æ´¢¹ý³Ì¡£
×÷Óã¬ÒÔ²Ù×÷ϵͳ
ÃüÁîÐнâÊÍÆ÷µÄ·½Ê½Ö´Ðиø¶¨µÄÃüÁî×Ö
Ïà¹ØÎĵµ£º
--²é¿´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 ......
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 ......
¾¹ýºÃ¼¸ÌìµÄ·ÜÕ½£¬JDBCÖÕÓڳɹ¦Á¬½ÓÁËSQL Server 2000£¬ÆÚ¼ä×ßÁ˲»ÉÙÍä·£¬ÔÚÕâÀï·ÖÏíÎÒµÄÒ»µã¾Ñé
Ò»¡¢ÎҵĻ·¾³
Windows XP+JDK6u15+Microsoft SQL Server 2000£¨SP4£©+JCreator
ÎÒÏÈÔÚÍøÉÏÏÂÔØÊý¾Ý¿âÇý¶¯³ÌÐò£¬Ä¿Â¼ÏÂÓÐÈý¸ö°ümsbase.jar mssqlserver.jar msutil.jar
1 ......
¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾÕýÈ·ÅäÖá£
£¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......