Pl/sql µÄ×Ô¶¯ÌáʾºÍÌá½»£¨commit£©
×Ô¶¯ÌáʾµÄ¿ì½Ý¼ü£ºF6
¿ÉÒÔ¸ü¸Ä£ºTools->Preferences->User interface->Key Configuration ,ÔÚItemÁÐÀïÕÒµ½“Tools/Code Assistant”,ÔÚºóÃæ¶ÔÓ¦µÄ¿ì½Ý¸Ä³É×Ô¼ºÏ²»¶µÄ¡£
ĬÈÏÊDz»ÄÜ×Ô¶¯Ìá½»µÄ£¬°´ F10 ¼ü¿ÉÒÔÔÚ×ö¸ü¸ÄºóÌá½»¡£
Ïà¹ØÎĵµ£º
CREATE PROC [dbo].[UP_EC_JOB_UpdateAddressType]
(
@Count INT
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @TransactionNumber INT
DECLARE @Cursor CURSOR
SET @C ......
ÈëÃÅƪ
////////////////////////////////////////////
% : ±íʾ0~n¸öÈÎÒâ×Ö·û
_ : ±íʾµ¥¸öÈÎÒâ×Ö·û
[] :±íʾÔÚÀ¨ºÅÀïÁгöµÄÈÎÒâ×Ö·û
[^]:±íʾÈÎÒâ¸öûÓÐÔÚÀ¨ºÅÖÐÁгöµÄ×Ö·û
***********************
ϵͳÊý¾Ý¿â
MASTERÊý¾Ý¿â:
......
SQL SERVER 2008Öж¨Ê±±¸·ÝÊý¾Ý¿âÈÎÎñµÄ´´½¨Óëɾ³ý
[http://news.newhua.com/news1/program_database/2008/1215/0812151515485B22JHGBK9HJ87DK09D6958HB8K83EJ0053JKGC1A543.html]
ÓÉÓÚ֮ǰÊÇʹÓÃSQL SERVER 2000»òÕß2005£¬Õâ´Î¸ø¿Í»§°²×°Ê±Ê¹ÓÃ2008 SERVER£¬±¾ÒÔΪ´´½¨Êý¾Ý¿â¶¨Ê±±¸·ÝÈÎÎñ»áÓë2000/2005ÓкܴóÇø±ð£¬µ«¾ ......
ÓÐÀý±í£ºemp
emp_no name age
001 Tom 17
002 &nb ......
SQL SERVER2000´ò²¹¶¡ÎÊÌâ»ã×Ü ¡¾http://hi.baidu.com/yanhai/blog/item/cf67c2ce07a9f50992457e9d.html¡¿
SQL ServerµÄ²¹¶¡°æ±¾¼ì²é²»ÈçWindows ²¹¶¡°æ±¾¼ì²éÖ±½Ó£¬Ò»¸öϵͳ¹ÜÀíÔ±£¬Èç¹û²»Á˽âSQL Server°æ±¾¶ÔÓ¦µÄ²¹¶¡ºÅ£¬¿ÉÄÜÒ²»áÓöµ½Ò»µãÂé·³£¬Òò´ËÔÚÕâ˵Ã÷һϣ¬Í¨¹ýÕâÑùµÄ°ì·¨Åбð»úÆ÷ÊÇ°²È«µÄ°ì·¨£¬²»»á¶Ôϵͳ²úÉúÈ ......