ACCESSÊý¾Ý¿â ×ö·ÖҳдSQLµÄÎÊÌâ
select top 20 * from tb
where ×Ö¶ÎÃû not in
(select top 10 ×Ö¶ÎÃû from tb)
ÎÒÖªµÀÓÃÕâÖÖ·½·¨¿ÉÒԵõ½10-20µÄÊý¾Ý
µ«ÊÇÈç¹ûÊý¾ÝºÜ¶à
±ÈÈçselect top 100020 * from tb
where ×Ö¶ÎÃû not in
(select top 100010 ×Ö¶ÎÃû from tb)ËäÈ»¿ÉÒԵõ½100010-10020Õâ10ÌõÊý¾Ý µ«ÊÇËٶȺÜÂý ÒòΪҪ´ò¿ªÇ°100020ºÍ10010µÄÊý¾Ý²¢ÇұȽÏ
ÇëÎÊ´ó¼ÒÔÚʹÓÃaccessÊý¾Ý¿âÊÇÈçºÎ·ÖÒ³µÄ
ÒòΪÊÇaccessµ±È»Ã»ÓÐsqlserverÄÇô¶àº¯ÊýÁË
LS?
±íÖн¨Ò»¸ö×ÔÔöÁУ¬È»ºó¸ù¾ÝÒ³ÊýºÍÒ³´óС£¬¼ÆËã³ö×ÔÔöÁеÄÖµ·¶Î§¡£ÕâÑùЧÂÊÓ¦¸ÃºÃºÜ¶à¡£
2lµÄ ÄãµÄÄÇÊÇɶ¶«Î÷
accessµÄ²»»á,°ï¶¥.
lkjhlkjhjkhjk
ÐèÒªÔÚIDÅÅÐò×Ö¶ÎÊÇÓÐË÷Òý¡£
SQL code:
select top 10 *
from (
select top 10000 *
from tbl01
order by id
) order by id desc
»òÕßÕâÑù »òÐí»á¿ìÉÏһЩ¡£
SQL code:
select top 10 * from tbl01
where id>(select max(id) from (
select top 10000 *
from tbl01
order by id ))
order by id
ѧϰ
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò
ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
òËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......