ÔõôʹÎÒÿ´Î²»ÊǸüÐÂÊý¾Ý¿â
¶øÊǸ²¸ÇÉϴεÄËùÓмǼÄØ£¡
ÒòΪÓÐʱºòʱ¼äÌõ¼þ²»Í¬
SQL code:
select * from hwouttb where
CAST(REPLACE(REPLACE(REPLACE(outdate,'Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
between
CAST(REPLACE(REPLACE(REPLACE('2007Äê10ÔÂ25ÈÕ','Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
and
CAST(REPLACE(REPLACE(REPLACE('2007Äê10ÔÂ25ÈÕ','Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
and (gysh like '%Éú產%' or gysh like '%¹¤³Ì%' or gysh like '%倉庫%')
union all
select * from hwouttb2 where
CAST(REPLACE(REPLACE(REPLACE(outdate,'Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
between
CAST(REPLACE(REPLACE(REPLACE('2007Äê10ÔÂ25ÈÕ','Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
and
CAST(REPLACE(REPLACE(REPLACE('2007Äê10ÔÂ25ÈÕ','Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
and (gysh like '%Éú產%' or gysh like '%¹¤³Ì%' or gysh like '%倉庫%')
ʲôÒâ˼£¿
¿´²»¶®,ÓÐÇëСPÁº.
sqlÉÙcopyµÄÒ»ÐÐ
¾ÍÊǵÚÒ»´Î¼ÙÈçÊÇ100Ìõ¼Ç¼
µÚ¶þ´ÎÊÇ50Ìõ¼Ç¼
ÄÇôÎÒÔÚÊý¾Ý¿âhwouttb3
Ò²Ö»ÓÐ50Ìõ¸Õ²ÅµÄ¼Ç¼
SQL code:
insert into hwouttb3
select * from hwouttb where
CAST(REPLACE(REPLACE(REPLACE(outdate,'Äê','-' ),'ÔÂ','-'),'ÈÕ','') AS DATETIME)
between
C
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......