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
Ïà¹ØÎĵµ£º
--²éѯÿ¸öÈ˶©·¹µÄ´ÎÊý
select username as ÐÕÃû, count(*) as ´ÎÊý from orderitems group by UserName having count(*)=1
order by ÐÕÃû desc
select distinct username as δע²áÐÕÃû from orderitems
where username not in (select [Name] from Person)
select distinct username as ÒÑ×¢²áÐÕÃû fr ......
²Ù×÷²½ÖèÈçÏ£¬¹©²Î¿¼¡£
Êý¾Ý¿âתÐ͹¤×÷Éæ¼°µÄ¹¤×÷ÊÂÏî·ÖÎö£º±í£¬±íÊý¾Ý£¬Ë÷Òý£¬Íâ¼üÔ¼Êø£¬×Ö¶ÎĬÈÏÖµ¡£
´æ´¢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷¡¢ÊÓͼµÈÓÉÓÚÓï·¨´æÔÚ²îÒ죬ֻÄÜ×ÔÐиÄд´¦Àí¡£
(Ò»)ÔÚMS SQL SERVER·þÎñÆ÷¶ËµÄ×¼±¸¹¤×÷¡£
1).´´½¨¹ØÓÚ±í¡¢ÊÓͼ¡¢Ö÷¼ü¡¢Ë÷Òý¡¢×Ö¶Î×ֵ䡢ĬÈÏÖµÔ¼ÊøµÄ¶ÔÏóÊÓͼ¡£ÒÔ·½±ãÏÂÒ»²½ ......
ÓÃ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Êý¾Ý¿âÖн¨Á¢É豸£¬½¨Á¢Êý¾Ý¿â£¬½¨Á¢±í¸ñ£¬·ÖÅäȨÏ޵ȹ¦ÄÜ£¬ÈçºÎ·½±ãµÄ½¨Á¢Ó¦ÓóÌÐòËùÐèSql Server»·¾³µÄÊý¾Ý¿â»·¾³£¬¶ø²»ÓÃÆô¶¯SQL Enterprise ManagerÄØ£¿
ÏÂÃæÀ´¿´£º
¡¡¡¡Æô¶¯VB6.0£¬Ð½¨Ò»¸ö¹¤ ......
VBʵÏÖSQL ServerÊý¾Ý¿â±¸·Ý/»Ö¸´
http://blog.csdn.net/cncco/archive/2006/05/15/729356.aspx
’**Ä£ ¿é Ãû£ºfBackupDatabase_a
’**Ãè Êö£º±¸·ÝÊý¾Ý¿â,·µ»Ø³ö´íÐÅÏ¢,Õý³£»Ö¸´,·µ»Ø""
’**µ÷ ÓãºfBackupDatabase_a "±¸·ÝÎļþÃû","Êý¾Ý¿âÃû"
’**²ÎÊý˵Ã÷£ ......