ÔÚSQL ServerÖÐÈçºÎÊä³öÐкÅ
ÔÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØÏµÊý¾Ý¿âÖУ¬±íÖеÄÐÐÊÇûÓÐÐòµÄ²¢ÇÒÐкÅûÓÐÕýÕæµÄÒâÒå¡£Èç¹ûÐèÒªÕâ¸ö¹¦ÄÜ£¬¿ÉÒÔÓÐÈçÏÂÈýÖÖ¿¼ÂÇ£º
ÔÚ±íÖÐÌí¼ÓÒ»¸ö×Ô¶¯Ôö³¤ÁС£
ʹÓÃÏÂÁвéѯΪÿһÐвúÉúÒ»¸öÐкš£ÏÂÁвéѯΪpubsÊý¾Ý¿âÿһÐвúÉúÒ»¸öÐкš£ÎªÕâ¸ö²éѯ¹¤×÷£¬Õâ¸ö±í±ØÐëÓ´Î¨Ò»Ô¼Êø¡£
-----------------------------------------------
SELECT (SELECT COUNT(i.au_id)
from pubs..authors i
WHERE i.au_id >= o.au_id ) AS RowID,
au_fname + ' ' + au_lname AS 'Author name'
from pubs..authors o
ORDER BY RowID
-----------------------------------------
ʹÓÃÁÙʱ±íʵÏÖ£¬½«Õû¸ö½á¹û¼¯´æ´¢ÔÚÒ»¸öÁÙʱ±íÖУ¬¸úÓÐÒ»¸öÓÉIDENTITY()º¯Êý²ÎÊýµÄÐкš£´´½¨ÁÙʱ±í´ú¼ÛÊDZȽϰº¹óµÄ£¬ÓÈÆäÊǶԱȽϴóµÄ±í½øÐвÙ×÷¡£
Ïà¹ØÎĵµ£º
1¡¢Á¬½ÓOracleÊý¾Ý¿â
Æô¶¯SQL*Plus£¬ÒªÇóÊäÈëUser Name¡¢Password¡¢Host StringÕâÈý¸ö²ÎÊý£¬ÀýÈçÎÒÔÚ°²×°µÄʱºòĬÈÏ´´½¨µÄÊý¾Ý¿âΪorcl£¬Ò²¾ÍÊÇSID£¬ÃÜÂëҲΪorcl£¬¶ÔÓ¦ÉÏÃæµÄÈý¸ö²ÎÊýÈçÏÂËùʾ£º
User Name£ºorcl
Password£ºorcl
Host String£ºorcl as sysdba
¾Í¿ÉÒԵǼ³É¹¦¡£
»òÕßÒ²¿ÉÒÔʹÓÃĬÈϵÄscottÀ´µÇ¼£º
......
£Ó£Ñ£Ì×¢ÈëÊÇ´ÓÕý³£µÄWWW¶Ë¿Ú·ÃÎÊ£¬¶øÇÒ±íÃæ¿´ÆðÀ´¸úÒ»°ãµÄWebÒ³Ãæ·ÃÎÊÃ»Ê²Ã´Çø±ð£¬ ËùÒÔĿǰÊÐÃæµÄ·À»ðǽ¶¼²»»á¶Ô£Ó£Ñ£Ì×¢Èë·¢³ö¾¯±¨£¬Èç¹û¹ÜÀíԱû²é¿´IISÈÕÖ¾µÄϰ¹ß£¬¿ÉÄܱ»ÈëÇֺܳ¤Ê±¼ä¶¼²»»á·¢¾õ¡£
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚÕâ¸öÐÐÒµµÄÈëÃÅÃż÷²»¸ß£¬³ÌÐòÔ±µ ......
string s = " 80,81,83,82";
string[] s1 = s.Split(',');
int[] p = new int[s1.Count()];
for (int i = 0; i < s1.Count( ......