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

Çó²»ÓÃrownumµÄ·ÖÒ³sqlÓï¾ä

ÎÒÔ­À´ÊÇÕâÑùµÄ£¬
SQL code:
select * from (select S.*,rownum rn from S where rn<=10) where rn > 0
£¬
µ«ÊÇÎÒÀûÓÃ.net½øÐиüеÄʱºò³ö´íÁË
C# code:
dataAdapter.Update(dataSet)

ËùÒÔÎÒ¾õµÃÊÇrownumµÄÎÊÌ⣬Çë¸ßÊÖ°ïæ,²»ÓÃrownumµÄ¡£
SQL code:
--°Ñ10ºÍ20×÷Ϊ²ÎÊý´«Èë¾Í¿ÉÒÔÁË
SELECT *
from (SELECT A.*, rownum r
from (SELECT * from S ORDER BY id DESC) A
WHERE rownum <= 20) B
WHERE r > 10;


SQL code:
--rownum±¾ÉíÊÇûÓÐÎÊÌâµÄ
--Ò²¿ÉÓ÷ÖÎöº¯ÊýÀ´ÊµÏÖ
SELECT * from (SELECT s.*, row_number() over(ORDER BY id) rn from S) A
WHERE rn BETWEEN 10 AND 20;


C# code:

dataAdapter.Update(dataSet)



Õâ¸ö²»¾ÍÊÇͼ·½±ãÂð....×Ô¼ºÐ´¸ö¸üÐÂÓï¾ä¾Í¿ÉÒÔÁË

.net ×Ô¼ºµÄ»úÖÆ¶ÔORACLEÒ²²»ÊÇÍêȫ֧³ÖµÄ,Ëü²»ÊÇSQL SERVER 





ºÇºÇ Â¥ÉÏÕý½â

±§Ç¸ ´ò½øÀ´µÄʱºò´íÁË ³ÌÐòÖеĴúÂëÊÇÕýÈ·µÄ

ͬÑùµÄ


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

¸ß·ÖÇósqlserverдexcel - MS-SQL Server / ÒÉÄÑÎÊÌâ

1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ