SQL SERVER¿ì½Ý¼ü
SQL SERVER¿ì½Ý¼ü
ÊéÇ©£ºÇå³ýËùÓÐÊéÇ©¡£
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+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
±à¼£ºÉ¾³ý×¢ÊÍ¡£
CTRL+SHIFT+R
±à¼£ºÖظ´ÉÏ´ÎËÑË÷»ò²éÕÒÏÂÒ»¸ö¡£
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
ÓÅ»¯£ºÏÔʾ·þÎñÆ÷¸ú×
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......
ÐÅÏ¢±í(infor)¹¤×ʱí(pay)
ÄÚÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay join infor on infor.name=PAY.name
×óÍâÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay left join infor on infor.name=PAY.name
PS£º½á¹ûÓÐÍõÎ壬¹¤×ÊΪ0
ÓÒÍâÁ¬½Ó
select pay.name,info ......
select GETDATE() as 'µ±Ç°ÈÕÆÚ',
DateName(year,GetDate()) as 'Äê',
DateName(month,GetDate()) as 'ÔÂ',
DateName(day,GetDate()) as 'ÈÕ',
DateName(dw,GetDate()) as 'ÐÇÆÚ',
DateName(week,GetDate()) as 'ÖÜÊý',
DateName(hour,GetDate()) as 'ʱ',
DateName(minute,GetDate()) as '·Ö',
DateName(second,Ge ......