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

SQLµÄ·ÖÒ³²éѯ

·ÖÒ³²éѯµÄÔ­Àí£º
 Õâ¸öÖ»ÄÜÓÃÔÙSql2005¼°ÒÔÉϵİ汾
DECLARE @pagenum AS INT, @pagesize AS INT  
SET @pagenum = 2   
SET @pagesize = 3   
SELECT *   
from (SELECT ROW_NUMBER() OVER(ORDER BY score DESC, speaker) AS rownum,    
        speaker, track, score   
      from SpeakerStats) AS D   
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize  
Õâ¸öÊÊÓÃÖ§³ÖtopµÄsql
SELECT TOP (10) * from hy_hotel_info   
 WHERE hi_id >(SELECT MAX (hi_id)    
from (select top £¨2*10£© hi_id    
from hy_hotel_info order by hi_id) as talTMP ) order by hi_id   
Ò»¸ö·ÖÒ³²éѯµÄ´æ´¢¹ý³Ì
/****** ¶ÔÏó: StoredProcedure [dbo].[SP_Pagination] ½Å±¾ÈÕÆÚ: 05/05/2010 15:02:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_Pagination]
@tblName varchar(255), -- ±íÃû .
@strGetFields varchar(1000) ='* ', -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255)= ' ', -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize int = 10, -- Ò³³ß´ç
@PageIndex int = 1, -- Ò³Âë
@doCount bit = 0, -- ·µ»Ø¼Ç¼×ÜÊý,·Ç 0 ÖµÔò·µ»Ø
@OrderType int = 0, -- ÉèÖÃÅÅÐòÀàÐÍ,·Ç 0 ÖµÔò½µÐò
@strWhere varchar(1500) =' ' , -- ²éѯÌõ¼þ(×¢Òâ: ²»Òª¼Ówhere)
@keyDate varchar(1500) =' '
AS
declare @strSQL varchar(5000) -- Ö÷Óï¾ä
declare @strTmp varchar(110) -- ÁÙʱ±äÁ¿
declare @strOrder varchar(400) -- ÅÅÐòÀàÐÍ
declare @fldNames varchar(100) -- ÅÅÐò×ֶΣ¬Èç¹ûÁ½Õűí,Ö»²éÑ


Ïà¹ØÎĵµ£º

SQL²åÈëÓï¾ä£¨INSERT INTO £©

INSERT INTO
 tableName ( columnName1, columnName2, columnName3, columnName4)
VALUES      (  '45', 'Î÷²Ø°ì',  TO_Date( '2010-03-10 12:00:00', 'YYYY-MM-DD HH24:MI:SS'), NULL,);
commit; ......

SQLÈ¡³öµÚ m Ìõµ½µÚ n Ìõ¼Ç¼µÄ·½·¨

´ÓTable ±íÖÐÈ¡³öµÚ m Ìõµ½µÚ n ÌõµÄ¼Ç¼£º(Not In °æ±¾)
SELECT TOP n-m+1 *
  from Table
  WHERE (id NOT IN (SELECT TOP m-1 id from Table ))
--´ÓTABLE±íÖÐÈ¡³öµÚmµ½nÌõ¼Ç¼ (Exists°æ±¾)
SELECT TOP n-m+1 * from TABLE AS a WHERE Not Exists
(Select * from (Select Top m-1 * from TABLE orde ......

oracle sql tuning

alert index mem_ct monitoring usage;
desc v$object_usage;
set linesize 190
select * from v$object_usage;
SQL>SET AUTOTRACE ON;
¡¡¡¡*autotrace¹¦ÄÜÖ»ÄÜÔÚSQL*PLUSÀïʹÓÃ
¡¡¡¡ÆäËûһЩʹÓ÷½·¨£º
¡¡¡¡2.2.1¡¢ÔÚSQLPLUSÖеõ½Óï¾ä×ܵÄÖ´ÐÐʱ¼ä
¡¡¡¡SQL> set timing on;
2.2.2¡¢Ö»ÏÔʾִÐмƻ®--(»áÍ¬Ê ......

SQL ɾ³ýÖØ¸´Êý¾Ý£¬Ö»±£Áô1Ìõ

if not object_id('Tempdb..#T') is null
    drop table #T
Go
Create table #T([ID] int,[Name] nvarchar(1),[Memo] nvarchar(2))
Insert #T
select 1,N'A',N'A1' union all
select 2,N'A',N'A2' union all
select 3,N'A',N'A3' union all
select 4,N'B',N'B1' union all
select 5,N'B',N'B2'
G ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ