vbÖ´ÐÐaccess sqlÓï¾ä¹ÖÎÊÌâ
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö
µ±ÎÒÓÃOleDbDataReaderÖ´ÐдËÓï¾äʱ»á³öÏÖ ¡°´Ó×Ö·û´®¡°SELECT Count(*) from In_fo ¡±µ½ÀàÐÍ¡°Double¡±µÄת»»ÎÞЧ¡£¡±
Çë¸ßÊÖÖ¸µãһϠid="+ userid +" ÈçºÎд²»»á³ö´í
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
userid Ó¦¸ÃҪת³É×Ö·ûÐ͵İÉ
ÎÒÒ²·¢ÏÖÁË Ð»Ð»
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÖØÐ°²×°sql server 2005ʱ£¬ÔÚ°²×°µ½ÀàËÆdata base service µÄ·þÎñʱ×ÜÊdzöÏîwindows installer µÄ´íÎó¡£
ÎÒÔÚÍøÉϲéÁ˽â¾öµÄ°ì·¨£¬ÏÈÍ£ÁËÕâ¸ö·þÎñ£¬È»ºóÖØÐÂÏÂÔØ°²×°ÁËInstMsiW.exe£¬È»ºóÓÖÆô¶¯Õâ¸ö·þÎñ£¬µ«ÊDz ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
SELECT ×Ö¶Î1
from ±í WHERE (...) AND ×Ö¶Î1=function()
×Ö¶Î1ÓпÉÄܵÄÖµ Ϊ 0 »òÕß -1
function ·µ»Ø 0 »òÕß -1
ÕâÑùµÄËÙ¶ÈÌ«ÂýÁË Çë¸ßÊÖ°ïæ
¶¨£¡
ÎÒд³ ......