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

ÇóÒ»ÌõSQLÓï¾ä¡£

ID  ²Í±ð    ʱ¼ä
1  ÖÐ²Í 2009-10-25
2  ÖÐ²Í 2009-10-26
3  Íí²Í 2009-10-26
4  Ôç²Í 2009-10-27

½á¹û
1  ÖÐ²Í 2009-10-25
3  Íí²Í 2009-10-26
4  Ôç²Í 2009-10-27

ÈÕÆÚÖÐÓÐÖØ¸´µÄ¡£¡£ÎÒÏëÒ»Ö±µÃµ½×îеġ£¡£°ïæллÁË
ËäÈ»¶Ô´ó¼ÒÓÐЩ¼òµ¥¡£µ«ÊÇÓÐûÓо­µäµÄË㷨ѽ¡£
ÕâÖÖÎÊÌâÔÚ±¨±íÖÐ×ÜÊdzöÏÖ¡£¡£

UP

SQL code:

select * from tb a where not exists(select 1 from tb where a.²Í±ð=²Í±ð and a.ʱ¼ä<ʱ¼ä)


SQL code:

--> ²âÊÔÊý¾Ý: @T1
declare @T1 table (ID int,²Í±ð varchar(4),ʱ¼ä datetime)
insert into @T1
select 1,'ÖвÍ','2009-10-25' union all
select 2,'ÖвÍ','2009-10-26' union all
select 3,'Íí²Í','2009-10-26' union all
select 4,'Ôç²Í','2009-10-27'

select * from @t1 a where not exists(select 1 from @t1 where a.²Í±ð=²Í±ð and a.ʱ¼ä> ʱ¼ä)

ID ²Í±ð ʱ¼ä
----------- ---- ------------------------------------------------------
1 ÖÐ²Í 2009-10-25 00:00:00.000
3 Íí²Í 2009-10-26 00:00:00.000
4 Ôç²Í 2009-10-27 00:00:00.000

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©
3Â¥Óеã´íÎó

SQL code
{{-


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

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

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

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Óï¾äÓÅ»¯¹¤¾ß£¿

ÇóSQLÓï¾äÓÅ»¯¹¤¾ß£¿
Õë¶ÔSQL ServerµÄ
·¢Ë͵½ÎÒÓÊÏäsclsmile@163.com
»òÕ߸øÎÒÒ»¸öÍøÖ·Á´½Ó
¹Ø×¢¡£

http://www.net130.com/class/oracle_datum_soft/Embarcadero%20SQLTuner%202.0.2.rar

http://sp ......

¹ØÓÚSQL 2008

Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£

лл£¡
ÎÒÒ²ÓÃ2000

1.Ì«¶àÁË ×Ô¼ºÈ¥ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ