½üÆÚÔÚ×öÒ»¸ö¹¦ÄÜʱ·¢Éú¹ÖÎÊÌâ.
==func.asp==
Function GetProductModel(productid)
Set conn1=Server.CreateObject("ADODB.Connection")
Set rs1=Server.CreateObject("ADODB.Recordset")
conn1.open DBCONN
sql1="select * from product where productid = "&pr ......
ÔÚaccessÊý¾Ý¿âÖн¨Á¢ÁËÒ»¸ö±íA£¬Í¬Ê±½¨Á¢¶à¸ö±í¹ØÁªËü £¬ÓÃalter table add constraint foreign key ʵÏÖ£¬²»¹ýºÃÏñaccessÖÐÓÐÏÞÖÆ¹ØÁªµ½Í¬Ò»¸ö±íµÄÊýÄ¿£¬µ±½¨Á¢¹ØÁªµÄ±í¶àµÄʱºòÌí¼ÓÍâ¼üµÄÓï¾äÔÚ³ÌÐòÖÐÖ´ÐÐʱ¾Í³ö´íÁË¡£
Õâ¸öÎÊÌâÄܲ»Äܽâ¾öÄØ£¿
²»»á°¡£¬Äã¼ÓÁ˶àÉÙ¸öµÄʱºò³öÎÊÌâµÄ£¿
¼ÓÁË30¶à¸ö
¶÷£¬¼ÓÁË30¶à¸ ......
×î½üÒ»Ö±ÔÚʹÓÃAccess2007×÷ΪÊý¾Ý¿â¿ª·¢Ð¡ÏîÄ¿¡£
Ò»¸öСÎÊÌ⣺ÏòAccessÊý¾Ý±í²åÈëÒ»ÌõÓï¾äºó£¬ÈçºÎÔٴλñÈ¡Ëü×ÔÔöÁеÄÖµ?
·½·¨£º
1.insert into Table1ºóÖ´ÐÐ×î´óÖµ²éѯ
select max(Id ) from Table1
2.insert into Table1ºóÖ´ÐÐselect @@identity
int Id = Convert.ToInt32(dbAccess.GetExecuteSca ......
AccessÖд洢µÄʱ¼ä¸úµ±Ç°Ê±¼ä±È½Ï£¬
Êý¾Ý¿âÖÐʱ¼ä¸ñʽ£º2005-7-5 15:23:35
select * from table1 where dateField < now()
ÆÕͨ±È½Ï£¬¾ÍÊÇÕâÑù£¬Èç¹ûÒª¼ÆËãÌ죬Ô£¬Ä꣬ÉõÖÁСʱ£¬·ÖÖӵ쬲î¶î¡£
¾ÍÒªÓõ½datediff(,,,)
ÀàËÆÕâÑù£º
select * from EventLog where theTime>=#2009-12-17 11: ......
ÎÒÕâ¸ö³ÌÐòÊǽ«²É¼¯µÄÊý¾ÝÏÈ·ÅÔÚÒ»¸öÊý×éÖÐdValue[6]£¬È»ºó°ÑÕâÊý×éÖеÄ7¸öÊý¾Ý·Ö±ð´æ½øACCESS ×Ö¶ÎÃû dValue0µ½dValue6ÖУ¬ÓÃsql Óï¾ä¸ÃÔõÑùʵÏÖ°¢£¿Õâ¸öÊý×éµÄÊý¾ÝҪʵʱ¸üеģ¬ÊäÈë½øACCESSҪʹÓÃÑ»·Âð£¿
ÏÈлл¸ßÊÖµÄÖ¸µãÁË¡£
http://download.csdn.net/source/1070271
×Ô¼º¿´Àý ......
ÔÚACCESSÖеIJéѯÓï¾äSELECT ygname, ygcl.cpid, ygcl.cpname, cpxx.cpprice, sum(iif(val(jh)=3,0,iif(left(ygcl.bzcode,2)='04' or left(ygcl.bzcode,2)='05',round(val(cl)/val(zxs)*val(xs)*val(cpxx.cpprice),2),iif(val(cl)=0,round(val(cpxx.cpprice)*val(xs),2),round(val(cl)*val(xs)*val(cpxx.cp ......