Çó²»ÓÃ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
ºÇºÇ Â¥ÉÏÕý½â
±§Ç¸ ´ò½øÀ´µÄʱºò´íÁË ³ÌÐòÖеĴúÂëÊÇÕýÈ·µÄ
ͬÑùµÄ
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......