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

SQLÈÕÆÚת»»~

ÏÂÃæµÄÈÕÆÚÎÒÒªÓñäÁ¿±íʾ
µ«ÎÒ½ÓÊÕµÄÈÕÆÚµÄ¸ñʽÓëÏÂÃæ²»Í¬
  ÎÒ½ÓÊÕµÄÈç 2009-10-10
ÎÒÓ¦¸ÃÔõô±äÄØ£¿
ÿ´Î¶¼°Ñ date1  ºÍdate2ÓÃString ÕâÑùÊDz»ÊDz»ºÃ
SQL code:

between '" + date1 + "' nad '" + date2 + "'


SQL code:

insert into hwouttb3
select * from hwouttb where outdate between '2007Äê10ÔÂ25ÈÕ' and '2007Äê11ÔÂ25ÈÕ'and gysh like '%Éú產%' or gysh like '%¹¤³Ì%' or gysh like '%倉庫%'
union all
select * from hwouttb2 where outdate between '2007Äê10ÔÂ25ÈÕ' and '2007Äê11ÔÂ25ÈÕ'and gysh like '%Éú產%' or gysh like '%¹¤³Ì%' or gysh like '%倉庫%'


'2007Äê10ÔÂ25ÈÕ'

²»Ö§³ÖµÄÈÕÆÚ¸ñʽ.

½«ÈÕÆÚת»»Ò»Ï¸ñʽconvert(varchar(10), outdate ,110)

Â¥Ö÷µÄÒâ˼ ÎÒ²»Ì«Çå³þ¡£µ«ÊÇÈç¹û ÊÇdatetimeÀàÐ굀 ¶¼ÊÇÄÜÓÃbetween and µÄ¡£
Â¥Ö÷ΨһÐèҪעÒâµÄÊÇ ½ÓÊÕµ½µÄÈÕÆÚ¸ñʽsql server ÊÇ·ñʶ±ð

ÒýÓÃ
'2007Äê10ÔÂ25ÈÕ'

²»Ö§³ÖµÄÈÕÆÚ¸ñʽ.

²»Ö§³ÖµÄÈÕÆÚ¸ñʽ£¿
  SQL²»Ö§³Ö£¿

outdate ÊÇʲôÀàÐ͵Ä

¼ÈÈ»ÊÇString ÀàÐÍ

String ÀàÐÍ
¿ÉÒÔÓÃbetween and Âð£¿


Ò²¿ÉÒÔÓüÆËãÁУ¬²»¹ýÈç¹ûÖмäÓзǷ


Ïà¹ØÎÊ´ð£º

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

ÇósqlÓï¾ä

pln_id memo
  1    ÎÒÊÇ
  1    ÄãºÃ
  2    ÄãÊÇ
  2    ÎÒºÃ

½á¹û

  pln_id memo 
    ......

¸üÐÂsqlÓï¾ä

ÎÒµÄÓï¾äΪstr1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=m_xb1",
m_bt, strTemp, fromClipboard);
ÆäÖÐCString m_xb1;±£´æµÄÖµ£¬µ«ÊÇÕâ¸öÓï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ