ÇóÒ»Ìõ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 table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÇóSQLÓï¾äÓÅ»¯¹¤¾ß£¿
Õë¶ÔSQL ServerµÄ
·¢Ë͵½ÎÒÓÊÏäsclsmile@163.com
»òÕ߸øÎÒÒ»¸öÍøÖ·Á´½Ó
¹Ø×¢¡£
http://www.net130.com/class/oracle_datum_soft/Embarcadero%20SQLTuner%202.0.2.rar
http://sp ......
Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£
лл£¡
ÎÒÒ²ÓÃ2000
1.Ì«¶àÁË ×Ô¼ºÈ¥ ......