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

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

°ï¶¥°É........

ÎÒÏëÁËÒ»¸öÕâÑùµÄ,²»ÖªµÀÊÇ·ñÐеÃ


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ