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
Ïà¹ØÎĵµ£º
×î¼Ñ´ð°¸·½·¨1£º
ÔÚ²éѯ·ÖÎöÒÇÀïÃæÔËÐÐÏÂÃæ´úÂ룺
backup log dbname with NO_LOG
backup log dbname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(dbname)
·½·¨2£º
½øÈëÆóÒµ¹ÜÀíÆ÷£¬Ñ¡ÖÐÊý¾Ý¿â
ËùÓÐÈÎÎñ->·ÖÀëÊý¾Ý¿â
µ½Êý¾Ý¿âÎļþµÄ´æ·ÅĿ¼£¬½«dbname_log.LDFÎļþɾ³ý£¬ÅÂSµÄ»° ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì
......
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ÷Éϵķ½·¨£¬ÏÖÒѽâ¾öÁË£¬ÏàÐÅÒ²Óв»ÉÙÏóÎÒÕâÑùµÄºüÓÑÃÇ¡£¹Ê´Ë£¬ÏÖÔÚ°ÑÎÒʵÏֵķ½·¨Ä ......
DELETE from SCOTT.EMP;
DROP from SCOTT.EMP;
TRUNCATE from EMP;
Ïàͬµã
truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã:
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigge ......