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

SQLPLUS Ï¿ÉÒÔÏÔʾsqlÓï¾äÖ´ÐÐʱ¼äµÄÃüÁî

SET TIMING ON | OFF
SQL> set timing on
SQL> select * from emp where empno = 7369;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ----------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 18-DEC-1980 800
20
Elapsed: 00:00:00.04
SQL> set timing off
SQL> /
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ----------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 18-DEC-1980 800
20
SQL> SET TIMING
SP2-0265: timing must be set ON or OFF

½øÈësqlplus
SQL> set timing on
SQL>
SQL> select count(*) from comm_human_role;
COUNT(*)
----------
866
Elapsed: 00:00:00.05
ÒÔÉÏÊý×ÖÊä³ö·Ö±ðÊÇ£ºHours:Minutes:Seconds.Milliseconds
¼´ÓÃÁË0.05ÃëµÄʱ¼äÖ´ÐУ¬Ï൱ÓÚ50ºÁÃë¡£
ʱ¼äÈç¹ûÊÇÕâÑùµÄ±íʾ£º00: 03: 235.78
×ܹ²ÓõÄʱ¼äΪ235.78Ã룬 ²»µ½4·ÖÖÓ£¬ËùÒÔÏÔʾµÄÊÇ3·ÖÖÓ£¨235.78Ãë´óԼΪ3·ÖÖÓ55.78Ã룩
#ÉèÖÃÆÁÄ»Ðпí¶È
SQL>set linesize 190
#ÉèÖÃsqlplus´òÓ¡Ö´Ðмƻ®ºÍͳ¼ÆÐÅÏ¢
SQL>set autotrace on
#ÉèÖÃsqlplus´òÓ¡Ö´ÐÐʱ¼ä
SQL>set timing on
Èç¹ûÔÚsqlplusÖгöÏÖÏÂÃæµÄ´íÎó£º
SP2-0027: Input is too long (> 2499 characters) - line ignored
±íʾsqlÒ»ÐеÄÓï¾äÒѾ­³¬¹ýÁË2499¸ö×Ö·û¡£
½â¾ö£º
ÔÚÒ»¶ÎsqlÖмӓ»Ø³µ”£¬
±£Ö¤Ã¿Ðв»³¬2499¸ö×Ö·û£¬ÖØÐÂÖ´ÐÐsqlÓï¾ä¾ÍºÃÁË
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/20296.htm


Ïà¹ØÎĵµ£º

SQLÈÕÖ¾ÎļþÌ«´ó,ÇåÀí·½·¨

×î¼Ñ´ð°¸·½·¨1£º 
ÔÚ²éѯ·ÖÎöÒÇÀïÃæÔËÐÐÏÂÃæ´úÂ룺 
backup log dbname with NO_LOG
backup log dbname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(dbname)
·½·¨2£º 
½øÈëÆóÒµ¹ÜÀíÆ÷£¬Ñ¡ÖÐÊý¾Ý¿â 
ËùÓÐÈÎÎñ->·ÖÀëÊý¾Ý¿â 
µ½Êý¾Ý¿âÎļþµÄ´æ·ÅĿ¼£¬½«dbname_log.LDFÎļþɾ³ý£¬ÅÂSµÄ»° ......

½«Êý¾Ý¿â±íÖеÄÊý¾ÝתΪsqlÖеÄinsertÓï¾ä

 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì ......

1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server

¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
      ½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ÷Éϵķ½·¨£¬ÏÖÒѽâ¾öÁË£¬ÏàÐÅÒ²Óв»ÉÙÏóÎÒÕâÑùµÄºüÓÑÃÇ¡£¹Ê´Ë£¬ÏÖÔÚ°ÑÎÒʵÏֵķ½·¨Ä ......

[SQLɾ³ý] SQLÓï¾äÖÐdelete, drop, truncate±È½Ï


DELETE from SCOTT.EMP;
DROP from SCOTT.EMP;
TRUNCATE from EMP;
Ïàͬµã 
truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý 
²»Í¬µã: 
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå) 
    dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigge ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ