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
ÓÅ»¯£ºÏÔʾ·þÎñÆ÷¸ú×
Ïà¹ØÎĵµ£º
--µ±Ç°Ê¹ÓõÄÊý¾Ý¿âÊÇ ÏµÍ³×Ô´øµÄ master
create database temp1
go --´Ë´¦²»¼ÓgoµÄ»°ÏÂÃæuse temp1 »á±¨´í£ºÕÒ²»µ½´æ´¢¹ý³Ì 'temp1'¡£
use temp1
set xact_abort on
begin tran
create table [order]( --orderÊǹؼü×Ö±ØÐëÓÃ[ ]£»
id int
)
create table fOrder(
id int
)
-- ÏÂÃæµÄ²Ù×÷Ö÷ÒªÊÇΪÁËʵÏÖfO ......
create procedure DeleteWareHouse_StoreArea_SummaryByPUR
(@po_no nvarchar(100))
as
begin
declare @cacheTable table(wh_id int);--ÉùÃ÷Ò»¸ötableÀàÐ͵ıäÁ¿
insert @cacheTable select wh_id from aps_inventory_store_area where description=@po_no--Ïò±äÁ¿@cacheTableÖÐÌí¼Ó½á¹û¼¯
--select * from @cac ......
1¡£select * from v$nls_parameters
²éѯnlsµÄ²ÎÊý£¬»ñµÃÊý¾Ý¿â·þÎñÆ÷¶ËµÄ×Ö·û±àÂë
NLS_LANGUAGE
NLS_CHARACTERSET
2¡£Ð޸ı¾µØ»·¾³±äÁ¿£¬ÉèÖÃ
NLS_LANG = SIMPLIFIED CHINESE.ZHS16GBK //Õâ¸öÊÇÎÒÃǵÄÊý¾Ý¿â×Ö·û±àÂë
NLS_LANG¸ñʽ£º
NLS_LANG = language_territory.char ......
ϵͳҪÇó½øÐÐSQLÓÅ»¯£¬¶ÔЧÂʱȽϵ͵ÄSQL½øÐÐÓÅ»¯£¬Ê¹ÆäÔËÐÐЧÂʸü¸ß£¬ÆäÖÐÒªÇó¶ÔSQLÖеIJ¿·Öin/not inÐÞ¸ÄΪexists/not exists
Ð޸ķ½·¨ÈçÏ£º
inµÄSQLÓï¾ä
SELECT id, category_id, htmlfile, title, convert(varchar(20),begintime,112) as pubtime
from tab_oa_pub WHERE is_check=1 and
category_id in (sel ......
ͨ³£Ö´ÐÐsqlÓï¾ä£¬´ó¼ÒÓõĶ¼ÊÇexec£¬exec¹¦ÄÜÇ¿´ó£¬µ«²»Ö§³ÖǶÈë²ÎÊý£¬sp_executesql½â¾öÁËÕâ¸öÎÊÌâ¡£³Ò»¶Îsqlserver°ïÖú£º
sp_executesql
Ö´ÐпÉÒÔ¶à´ÎÖØÓûò¶¯Ì¬Éú³ÉµÄ Transact-SQL Óï¾ä»òÅú´¦Àí¡£Transact-SQL Óï¾ä»òÅú´¦Àí¿ÉÒÔ°üº¬Ç¶Èë²ÎÊý¡£
Óï·¨
sp_executesql
[@stmt
=
] stmt
[
&n ......