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

SQL ³£Óÿì½Ý¼ü´óÈ«

ÊéÇ©£ºÇå³ýËùÓÐÊéÇ©¡£ CTRL-SHIFT-F2
ÊéÇ©£º²åÈë»òɾ³ýÊéÇ©(Çл»)¡£ CTRL+F2
ÊéÇ©£ºÒƶ¯µ½ÏÂÒ»¸öÊéÇ©¡£ F2 ¹¦Äܼü
ÊéÇ©£ºÒƶ¯µ½ÉÏÒ»¸öÊéÇ©¡£ SHIFT+F2
È¡Ïû²éѯ¡£ ALT+BREAK
Á¬½Ó£ºÁ¬½Ó¡£ CTRL+O
Á¬½Ó£º¶Ï¿ªÁ¬½Ó¡£ CTRL+F4
Á¬½Ó£º¶Ï¿ªÁ¬½Ó²¢¹Ø±Õ×Ó´°¿Ú¡£ CTRL+F4
Êý¾Ý¿â¶ÔÏóÐÅÏ¢¡£ ALT+F1
±à¼­£ºÇå³ý»î¶¯µÄ±à¼­Æ÷´°¸ñ¡£ CTRL+SHIFT+DEL
±à¼­£º×¢ÊÍ´úÂë¡£ CTRL+SHIFT+C
±à¼­£ºÉ¾³ý×¢ÊÍ¡£ CTRL+SHIFT+R
±à¼­£º¸´ÖÆ¡£»¹¿ÉÒÔʹÓà CTRL+INSERT¡£ CTRL+C
±à¼­£º¼ôÇС£»¹¿ÉÒÔʹÓà SHIFT+DEL¡£ CTRL+X
±à¼­£º¼õСËõ½ø¡£ SHIFT+TAB
±à¼­£ºÔڱ༭Æ÷´°¸ñÖÐɾ³ýÖÁÐÐβ¡£ CTRL+DEL
±à¼­£º²éÕÒ¡£ CTRL+F
±à¼­£º×ªµ½Ðкš£ CTRL+G
±à¼­£ºÔö´óËõ½ø¡£ TAB
±à¼­£ºÊ¹Ñ¡¶¨ÄÚÈÝΪСд¡£ CTRL+SHIFT+L
±à¼­£ºÊ¹Ñ¡¶¨ÄÚÈÝΪ´óд¡£ CTRL+SHIFT+U
±à¼­£ºÕ³Ìù¡£»¹¿ÉÒÔʹÓà SHIFT+INSERT¡£ CTRL+V
±à¼­£ºÖظ´ÉÏ´ÎËÑË÷»ò²éÕÒÏÂÒ»¸ö¡£ F3 ¹¦Äܼü
±à¼­£ºÌæ»»¡£ CTRL+H
±à¼­£ºÈ«Ñ¡¡£ CTRL+A
±à¼­£º³·Ïû¡£ CTRL+Z
Ö´Ðвéѯ¡£»¹¿ÉÒÔʹÓà CTRL+E (Õë¶ÔÏòºó¼æÈÝÐÔ)¡£ F5 ¹¦Äܼü
SQL ²éѯ·ÖÎöÆ÷°ïÖú¡£ F1 ¹¦Äܼü
¶ÔËùÑ¡ Transact-SQL Óï¾äµÄ°ïÖú¡£ SHIFT+F1
ä¯ÀÀ£ºÔÚ²éѯ´°¸ñºÍ½á¹û´°¸ñÖ®¼äÇл»¡£ F6 ¹¦Äܼü
ä¯ÀÀ£ºÇл»´°¸ñ¡£ Shift+F6
ä¯ÀÀ£º´°¿ÚÑ¡ÔñÆ÷¡£ CTRL+W
"н¨²éѯ"´°¿Ú¡£ CTRL+N
¶ÔÏóä¯ÀÀÆ÷(ÏÔʾ/Òþ²Ø)¡£ F8 ¹¦Äܼü
¶ÔÏóËÑË÷¡£ F4 ¹¦Äܼü
·ÖÎö²éѯ²¢¼ì²éÓï·¨¡£ CTRL+F5
´òÓ¡¡£ CTRL+P
½á¹û£ºÒÔ±í¸ñ¸ñʽÏÔʾ½á¹û¡£ CTRL+D
½á¹û£ºÒÔÎı¾¸ñʽÏÔʾ½á¹û¡£ CTRL+T
½á¹û£ºÒƶ¯²ð·ÖÆ÷¡£ CTRL+B
½á¹û£º½«½á¹û±£´æΪÎļþ¡£ CTRL+SHIFT+F
½á¹û£ºÏÔʾ½á¹û´°¸ñ(Çл»)¡£ CTRL+R
±£´æ¡£ CTRL+S
Ä£°å£º²åÈëÄ£°å¡£ CTRL+SHIFT+INSERT
Ä£°å£ºÌ滻ģ°å²ÎÊý¡£ CTRL+SHIFT+M
ÓÅ»¯£ºÏÔʾԤ¹ÀÖ´Ðмƻ®¡£ CTRL+L
ÓÅ»¯£ºÏÔʾִÐмƻ®(Çл»¿ª/¹Ø)¡£ CTRL+K
ÓÅ»¯£ºË÷ÒýÓÅ»¯Ïòµ¼¡£ CTRL+I
ÓÅ»¯£ºÏÔʾ¿Í»§Í³¼Æ CTRL+SHIFT+S
ÓÅ»¯£ºÏÔʾ·þÎñÆ÷¸ú×Ù¡£ CTRL+SHIFT+T
ʹÓÃÊý¾Ý¿â¡£ CTRL+U


Ïà¹ØÎĵµ£º

SQL SERVERÊý¾Ý¿â¿ìËÙתORACLEʵս

²Ù×÷²½ÖèÈçÏ£¬¹©²Î¿¼¡£
 Êý¾Ý¿âתÐ͹¤×÷Éæ¼°µÄ¹¤×÷ÊÂÏî·ÖÎö£º±í£¬±íÊý¾Ý£¬Ë÷Òý£¬Íâ¼üÔ¼Êø£¬×Ö¶ÎĬÈÏÖµ¡£
´æ´¢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷¡¢ÊÓͼµÈÓÉÓÚÓï·¨´æÔÚ²îÒ죬ֻÄÜ×ÔÐиÄд´¦Àí¡£
 
(Ò»)ÔÚMS SQL SERVER·þÎñÆ÷¶ËµÄ×¼±¸¹¤×÷¡£
1).´´½¨¹ØÓÚ±í¡¢ÊÓͼ¡¢Ö÷¼ü¡¢Ë÷Òý¡¢×Ö¶Î×ֵ䡢ĬÈÏÖµÔ¼ÊøµÄ¶ÔÏóÊÓͼ¡£ÒÔ·½±ãÏÂÒ»²½ ......

SQL Server 2000/2005 ·ÖÒ³SQL

SQL ServerÖм¸ÖÖ·ÖÒ³µÄsqlÓï¾ä
·½·¨1£º
ÊÊÓÃÓÚ SQL Server 2000/2005
SELECT TOP Ò³´óС *
from table1
WHERE id NOT IN
          (
          SELECT TOP Ò ......

ÓÃADO¹ÜÀíSQL SERVER

ÓÃADO¹ÜÀíSQL SERVER
http://blog.csdn.net/cncco/archive/2009/11/09/4789123.aspx
ÔÚÈí¼þ¿ª·¢ÖУ¬³£³£ÐèҪΪ³ÌÐò½¨Á¢Sql ServerÊý¾Ý¿âµÄÔËÐл·¾³¡£Íê³ÉÈçÔÚSQL ServerÊý¾Ý¿âÖн¨Á¢É豸£¬½¨Á¢Êý¾Ý¿â£¬½¨Á¢±í¸ñ£¬·ÖÅäȨÏ޵ȹ¦ÄÜ£¬ÈçºÎ·½±ãµÄ½¨Á¢Ó¦ÓóÌÐòËùÐèSql Server»·¾³µÄÊý¾Ý¿â»·¾³£¬¶ø²»ÓÃÆô¶¯SQL Enterprise Manage ......

±£»¤SQL ServerÊý¾Ý¿âµÄÊ®´ó¾øÕÐ

±£»¤SQL ServerÊý¾Ý¿âµÄÊ®´ó¾øÕÐ
http://blog.csdn.net/cncco/archive/2007/09/15/1785880.aspx
1. °²×°×îеķþÎñ°ü
ΪÁËÌá¸ß·þÎñÆ÷°²È«ÐÔ£¬×îÓÐЧµÄÒ»¸ö·½·¨¾ÍÊÇÉý¼¶µ½SQL Server 2000 Service Pack 3a (SP3a)¡£ÁíÍ⣬Äú»¹Ó¦¸Ã°²×°ËùÓÐÒÑ·¢²¼µÄ°²È«¸üС£
2. ʹÓÃMicrosoft»ùÏß°²È«ÐÔ·ÖÎöÆ÷£¨MBSA£©À´ÆÀ¹À·þÎñÆ÷µÄ°² ......

v$sql,v$sqlarea,v$sqltextÓÐʲôÇø±ð

v$sqltext
´æ´¢µÄÊÇÍêÕûµÄSQL
v$sqlarea
´æ´¢µÄSQL ºÍһЩÏà¹ØµÄÐÅÏ¢£¬±ÈÈçÀۼƵÄÖ´ÐдÎÊý£¬Âß¼­¶Á£¬ÎïÀí¶ÁµÈͳ¼ÆÐÅÏ¢
v$sql
´æ´¢µÄÊǾßÌåµÄSQL ºÍÖ´Ðмƻ®Ïà¹ØÐÅÏ¢£¬Êµ¼ÊÉÏ£¬v$sqlarea ¿ÉÒÔ¿´×ö v$sql ¸ù¾Ý sqltext µÈ ×öÁË group by Ö®ºóµÄÐÅÏ¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ