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

SQL²é詢語¾äSelect

SQL²é詢語¾äSelect
ÒªÇóÈçÏ£º£¨inputdatetime or Outputdatetime£© and Name
´ú碼ÈçÏ£º
sql = "select *from Info where inputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "#  or Outputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "#  and Name='" & ExportName.Text & " '"
Ŀǰ無·¨現實ÒªÇó£»
http://download.csdn.net/source/1644211

ÒýÓÃ
http://download.csdn.net/source/1644211

ÏÂ載²»ÁË£¬¿ÉÄÜÊÇ積·Ö²»夠°É£»
ÄÜ傳給ÎÒ嗎£¿TKS!
mail£ºgolden8510@163.com


ÒýÓÃ
ÒýÓÃÂ¥Ö÷ golden8510 µÄ»Ø¸´:
SQL²é詢語¾äSelect
ÒªÇóÈçÏ£º£¨inputdatetime or Outputdatetime£© and Name
´ú碼ÈçÏ£º
sql = "select *from Info whereinputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "# orOutputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "# andName='" & ExportName.Text & " '"
Ŀǰġ


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

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

¹ØÓÚ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Óï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
        @SYS_ORGANIZE varchar(10), ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ