Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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

½øÐÐÊ


Ïà¹ØÎÊ´ð£º

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÈçºÎÉ趨access logÖеÄauthenticated username?

ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿

Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ