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

SQL Server Management StudioÖС°ÒѽûÓôúÀí XP¡±

ÔÚSQL Server Management StudioÖÐÁ¬½Óµ½SQL ServerʵÀýºó£¬»áÏÔʾ“SQL Server ´úÀ픽ڵ㡣Èç¹ûµ±Ç°¸ÃʵÀýµÄAgent·þÎñûÓÐÆô¶¯£¬“SQL Server ´úÀ픺ó±ß¾Í»áÏÔʾ“(ÒѽûÓôúÀí¡¡XP)”¡£“ÒѽûÓôúÀí”´Ó×ÖÃæÉϲ»ÄÑÀí½â£¬ºó±ßµÄ“XP”ÓеãÈÃÈ˷ѽâÁË£¬Õâ¸ö·þÎñ¸úWindows¡¡XPϵͳ»¹ÓйØÏµÂ𣿵½ËÑË÷ÒýÇæÉÏËÑÁËһϣ¬Ã»ÓÐÏà¹ØµÄ˵Ã÷¡£ÔÚSQL¡¡ServerÁª»ú´ÔÊéÀïÕÒµ½Á˴𰸡£ÔÚSQL¡¡ServerÅäÖÃÑ¡Ïî±íÖÐÓÐÒ»Ïî“Agent XPs”£¬¸ÃÏîÊÇÓÃÀ´È·¶¨SQL¡¡Server¡¡Management¡¡StudioÖÐÊÇ·ñÏÔʾSQL¡¡Server´úÀí½ÚµãϵÄ×ӽڵ㡣ÔÚ´úÀí·þÎñδÆô¶¯µÄʱºò£¬¸ÃÏîĬÈÏΪ½ûÓã»·þÎñÆô¶¯ºó¸ÃÏî»á±»ÆôÓá£
µ±È»£¬ÔÚ·þÎñδÆô¶¯Ê±£¬Ö»Ð轫ÅäÖÃÏîµÄÖµÉèÖÃΪ£±¼´¿ÉÏÔʾ×ӽڵ㡣ͬÑù£¬ÔÚ·þÎñÆô¶¯ºó£¬½«ÅäÖÃÏîµÄÖµÉèÖÃΪ£°Ôò»áÒþ²Ø×ӽڵ㡣ÆôÓøÃÏîµÄ·½·¨ÊÇ
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO


Ïà¹ØÎĵµ£º

SQL³£ÓÃÃüÁîʹÓ÷½·¨

 
(1) Êý¾Ý¼Ç¼ɸѡ£º
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû=×Ö¶ÎÖµ order by ×Ö¶ÎÃû [desc]"
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû like '%×Ö¶ÎÖµ%' order by ×Ö¶ÎÃû [desc]"
sql="select top 10 * from Êý¾Ý±í where ×Ö¶ÎÃû order by ×Ö¶ÎÃû [desc]"
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû in ('Öµ ......

SQL×¢Èë©¶´È«½Ó´¥

 
¿´ÍêÈëÃÅÆªºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆÆ½âÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËÒ»Ð©ÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿ÔõôÑùÌá¸ß²Â½âЧÂÊ£¿Çë´ó¼Ò½Ó×ÅÍùÏ¿´¸ß¼¶Æª¡£
µÚÒ»½Ú¡¢ÀûÓÃϵͳ±í×¢ÈëSQLServerÊý¾Ý¿â
SQLServerÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âϵͳ£¬Óë²Ù×÷ϵͳҲÓнôÃܵÄÁªÏµ£¬Õâ¸ø¿ª·¢ ......

sql×Ö·û´®Ä£Ê½Æ¥Åä

 MySQLÌṩ±ê×¼µÄSQLģʽƥÅ䣬ÒÔ¼°Ò»ÖÖ»ùÓÚÏóUnixʵÓóÌÐòÈçvi¡¢grepºÍsedµÄÀ©Õ¹ÕýÔò±í´ïʽģʽƥÅäµÄ¸ñʽ¡£ ±ê×¼µÄSQLģʽƥÅä
SQLµÄģʽƥÅäÔÊÐíÄãʹÓÓ_”Æ¥ÅäÈκε¥¸ö×Ö·û£¬¶ø“%”Æ¥ÅäÈÎÒâÊýÄ¿×Ö·û(°üÀ¨Áã¸ö×Ö·û)¡£ÔÚ MySQLÖУ¬SQLµÄģʽȱʡÊǺöÂÔ´óСдµÄ¡£ÏÂÃæÏÔʾһЩÀý×Ó¡£×¢ÒâÔÚÄãÊ ......

SQL outputʹÓÃ

 Ò»Ö±Ã»ÓÐÕÒµ½Ò»Öֺõķ½·¨À´ÒýÓÃÓзµ»ØÖµµÄ´æ´¢¹ý³ÌµÄ·½·¨£¬Ê¹ÎÒÔÚÌí¼ÓÊý¾ÝÖÐ×ßÁ˲»ÉÙµÄÍä·£¬×î½ü£¬ÔÚ²éÔÄÁË´óÁ¿µÄ×ÊÁÏÖ®ºó£¬ÖÕÓÚÔÚ΢ÈíµÄÒ»¸öʵÀýÖÐÕÒµ½ÁËÒ»ÖÖÁ¼ºÃµÄ·½·¨¡£
Ê×ÏȱàдºÃÒ»Óзµ»ØÖµµÄ´æ´¢¹ý³Ì
create procedure proc_name
   @para1 nchar(20),    --ÊäÈë²ÎÊý
 &n ......

SQLÓï¾ä

 --Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW --´´½¨Ò»¸öÊÓÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ