100·Ö£¬ÇóÕâÑùµÄSQLÈçºÎд£¿»òʵÏÖ·½·¨¡£
ÔÚ×öÒ»¸öËÑË÷ÒýÇæÓÅ»¯³ÌÐò£¬ÓûʵÏÖÏÂÃæµÄ¹¦ÄÜ£º
´ÓTable1ÖÐÈ¡³ö¼Ç¼ÒÀ´Î½øÐеã»÷£¬µ«ÊÇ£¬Èç¹ûºÍTable2ÖбȽϣ¬Í¬¹Ø¼ü´Ê¡¢Í¬ÍøÖ·¡¢Í¬µã»÷IPµÄ¼Ç¼ÒѾÔÚTable2ÖдæÔÚ£¬ÄÇôTable1ÖеÄÕâÌõ¼Ç¼±ØÐëºÍTable2ÖÐÂú×ãÁËÉÏÊöÌõ¼þµÄ×îºóÒ»Ìõ¼Ç¼µÄµã»÷µÄʱ¼ä¼ä¸ô30·ÖÖÓÒÔÉÏ£¨Ò²¾ÍÊÇ´óÓÚ30·ÖÖÓ£©£¬²ÅÔÊÐíÔÙÖ´ÐÐTable1ÖеÄÕâÌõ¼Ç¼¡£ÕâÑù£¬ÎÒ²»ÖªµÀÈçºÎʵÏÖ£¿¾ßÌåµÄ±í½á¹¹ÊÇÕâÑùµÄ£¬
ÓÐÁ½¸ö±í£ºTable1£¬ÊÇ´æ·Å¹Ø¼ü´ÊºÍÍøÖ·µÄ£»Table2£¬ÊDZ£´æµÄµã»÷µÄÀúÊ·ÐÅÏ¢µÄ£¬IPÊÇͨ¹ý³ÌÐò»ñµÃµÄ£¬ÔÚµã»÷ºó¶¼·Åµ½Á˼ǼÖУ¬µã»÷ʱµÄIPÊÇÈ¡µÃµÄ¹«ÍøIP¡£
Êý¾Ý¿âÊÇMSSQLÀàÐ͵ġ£
Table1µÄ½á¹¹£º
¹Ø¼ü´Ê ÍøÖ·
·þ×° www.123.com
Ó¡Ë¢ www.567.com
¸ÖÌú www.3545.com
ÀñÆ· www.24234.com
ÏÊ»¨ www.2423432.com
... ...
Table2µÄ½á¹¹£º
¹Ø¼ü´Ê ÍøÖ· µã»÷IP µã»÷ʱ¼ä
·þ×° www.123.com 126.168.2.3 02 18 2010 4:55PM
ÀñÆ· www.24234.com 215.696.36.2 02 18 2010 6:02PM
Ó¡Ë¢ www.567.com 299.522.36.6 02 17 2010 6:02PM
... ...
Óô洢¹ý³Ì
@result bit output
select @maxclicktime=max(clicktime)
from table2
where
¡¡
set @timebtween=datediff(minute,@maxclicktime,getdate())
if @timebtween>30
begin
@result=1
end
else
begin
@result=0
end
°ï¶¥°É........
ÎÒÏëÁËÒ»¸öÕâÑùµÄ,²»ÖªµÀÊÇ·ñÐеÃ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......