Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Âð£¿


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


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sql±à¼­¹¤¾ß

´ó¼Ò¶¼ÓÃʲôsqlÓï¾ä±à¼­¹¤¾ß£¡»¹ÊÇÖ»½ÓÓòéѯ·ÖÎöÆ÷£¿ÍøÉÏÕÒÁËЩPL/SQL developerÕâºÃÏñÊÇÁ¬OraclerµÄ
ÎÒÖ»ÏëÒª¸öSQl±à¼­¹¤¾ß
SSMS.

²éѯ·ÖÎöÆ÷×ã¹»ÁË

±¾ÈË×î½üÔÚѧϰsql
µ«Ã¿´Î¶¼ÒªÍù²éѯ·ÖÎöÆ÷ÉÏÌ ......

¸üÐÂ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ºÅ