AccessÖеÄÊÇ/·ñ
Select a.ID,a.Name,(Select IIF(Count(*)>0,true,false) from a where a.ID=1) As IsOK from a where a.ID=1 ¼ìË÷³öÀ´ºó£¬°ÑIsOK×Ö¶Îת»»²»³ÉbooleanÀàÐ͵ģ¬ÌáʾSystem.Int16²»ÄÜת»»³ÉSystem.Boolean ÇëÎÊÈçºÎ½â¾ö£¬Ð»Ð»
true:-1 false:0 Select a.ID,a.Name,(Select IIF(Count(*)>0,-1,0) from a where a.ID=1) As IsOK from a where a.ID=1 ûÓа취£¬Õâ¸öOLEDBÀàÖеÄÎÊÌ⣬ACCESSͨ¹ýoleconnection »Ø¸øÒ»¸öintÊý×Ö ÄãÖ»ÄÜ×Ô¼ºÔÚC#ÖнøÐÐת»»ÁË¡£ÒýÓà ûÓа취£¬Õâ¸öOLEDBÀàÖеÄÎÊÌ⣬ACCESSͨ¹ýoleconnection »Ø¸øÒ»¸öintÊý×Ö ÄãÖ»ÄÜ×Ô¼ºÔÚC#ÖнøÐÐת»»ÁË¡£ ¶ÔÓÚ±íÖÐij¸ö×Ö¶ÎÊÇ ÊÇ·ñ ÀàÐ͵ģ¬ÊÇ¿ÉÒÔת»»µÄ£¬Õâ¸ö¡¡ÒýÓà true:-1 false:0 Select a.ID,a.Name,(Select IIF(Count(*)>0,-1,0) from a where a.ID=1) As IsOK from a where a.ID=1 °Ñtrue¸Ä³É-1¡¡±¨³öÒ»ÑùµÄ´íÎó ÄãÊÇÔÚÓïÑÔ»·¾³ÖÐÔËÐÐSQLÓï¾ä£¬´ò¿ª¼Ç¼¼¯£¿ Select a.ID,a.Name,(Select IIF(Count(*)>0,true,false) from a where a.ID=1) As IsOK from a where a.ID=1 Õâ¸öÓï¾äÏëʵÏֵŦÄÜÊÇʲô£¿ËƺõÂß¼ÉÏºÜÆæ¹Ö£¬Èç¹ûAÖÐÓÐid=1µÄ¼Ç¼£¬×ÔÈ»ÄãÓ¦¸Ã·µ»Ø isok = true,Èç¹ûûÓзûºÏÌõ¼þµÄ¼Ç¼£¬ÄãµÄÕâ¸öÓï¾äÁ¬Ò»Ìõ¼Ç¼¶¼²»»á·µ»Ø¡£ ÄãµÄÓï¾äÂß¼ÉϵÈЧÓÚ select id,name,true from a where id=1 ½øÐÐÊ
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý" ²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!! ´ó¼Ò¶¼ ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿ <%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿ Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ 2009-07-04 02:16:37 110.110 ......