Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

sqlÓï¾ä

1.´´½¨Ò»¸öÊý¾Ý¿âʱ
ÓдíÂð£¿Ëü×ÜÊÇÌáʾdbd.ldfÒѾ­´æÔÚ µ«ÊÇÔõô¸ÄÃû¶¼»¹ÊÇÒ»ÑùÌáʾ´æÔÚ
create database testdb
on primary
(name=db1,filename='e:\java\zy\dba.mdf',size=1,maxsize=5,file ......

ÇósqlÓï¾äÀí½â

±íA
¿¨ºÅ        ʱ¼ä
1                null
2                null
3      ......

sql±à¼­¹¤¾ß

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

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

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

ÐÂÊÖµÄSQL²éѯÎÊÌâ

    ±íÖеÄÒ»¸öÊôÐÔÁÐchoiceÓÐÁ½ÖÖ¿ÉÄܵÄÖµ£ºstringA,stringB£¬¶¼ÊÇ×Ö·û´®¡£
    ÎÒÓÃÒ»¸öresult(stringÀàÐÍ£©´æ´¢Ñ¡ÔñµÄ½á¹û
    SELECT * from tablename WHERE choice = res ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ