Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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; ......

Javascript :¡¡JSQL£¬SQLÎÞ´¦²»ÔÚ£¬

ÉÏ»ØËµµ½£¬²Ù×÷Object Array
Æäʵ»¹¿ÉÒÔÕâÑù²Ù×÷£º
var Room = [
            {
                ID: 'bot',
                name: 'test' ......

¡¾×ª¡¿¹ØÓÚ"µÝ¹éÊ÷ÐβéѯSQL"µÄºÃÌû

-----------------------------------------------------------------------------------------------------------------------
create table tb(id varchar(3) , pid varchar(3) , name varchar(10))
insert into tb values('001' , null  , '¹ã¶«Ê¡')
insert into tb values('002' , '001' , '¹ãÖÝÊÐ')
insert i ......

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ÓïÑÔ£ºÈçºÎÅжÏ×Ö¶ÎÊÇ·ñ´æÔÚ£¬ÈçºÎɾ³ý¼°´´½¨×Ö¶Î

ÈçºÎÅжÏ×Ö¶ÎÊÇ·ñ´æÔÚ
 if col_length('±íÃû','×Ö¶Î1') is null  ALTER TABLE ±íÃû ADD ×Ö¶Î1 Nvarchar(50)  if col_length('±íÃû','×Ö¶Î2') is null  ALTER TABLE ±íÃû ADD ×Ö¶Î2 Nvarchar(50) ");
ɾ³ý×Ö¶Î
if col_length('±íÃû','×Ö¶Î1,') is not null  ALTER TABLE ±íÃû drop  c ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ