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

¹ØÓÚSQL 2008

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

лл£¡
ÎÒÒ²ÓÃ2000

1.Ì«¶àÁË ×Ô¼ºÈ¥²éÏÂ
2.¿ÉÒÔ
3.ѸÀ×

²¹³ä: 2000µÄSQL½Å±¾£¬ÔÚ2008ÖÐÄÜÓÃÂð£¿

ÄÜÓÃ

ÓÐһЩ²»¿ÉÒÔÓà ÓÐЩ¿ÉÒÔÓà Ҫ¿´ÏòϼæÈÝÐÔµÄÎÊÌâ

ÒýÓÃ
ÓÐһЩ²»¿ÉÒÔÓà ÓÐЩ¿ÉÒÔÓà Ҫ¿´ÏòϼæÈÝÐÔµÄÎÊÌâ

СF²»É¢·Ö???¹§Ï²¹þ

ÒýÓÃ
ÒýÓà 5 Â¥ fredrickhu µÄ»Ø¸´:
ÓÐһЩ²»¿ÉÒÔÓà ÓÐЩ¿ÉÒÔÓà Ҫ¿´ÏòϼæÈÝÐÔµÄÎÊÌâ

СF²»É¢·Ö???¹§Ï²¹þ

?ΪʲôҪɢ·Ö£¿

ÒýÓÃ
ÓÐһЩ²»¿ÉÒÔÓà ÓÐЩ¿ÉÒÔÓà Ҫ¿´ÏòϼæÈÝÐÔµÄÎÊÌâ


ÖÜδÊÔÊÔ¡£¡£¡£Ð»Ð»

ÒýÓÃ
ÒýÓà 6 Â¥ sql77 µÄ»Ø¸´:
ÒýÓà 5 Â¥ fredrickhu µÄ»Ø¸´:
ÓÐһЩ²»¿ÉÒÔÓà ÓÐЩ¿ÉÒÔÓà Ҫ¿´ÏòϼæÈÝÐÔµÄÎÊÌâ

СF²»É¢·Ö???¹§Ï²¹þ

?ΪʲôҪɢ·Ö£¿

ÉýÐÇѽ,ºÇºÇ,

ÎÒ»¹Ê¹ÓõÄÊÇsqlserver2000ÄØ 


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

sql ʱ¼äÎÊÌâ

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

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

¹ØÓÚ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 Óï¾ä¡£¡£ Çë½Ì¸ßÊÖ

ÏÈÀ´Ò»¸ö´íÎóÓï¾ä¡£¡£
select * from [aa] where a1 in (select max(a2),a1 from [aa]  group by a1 )


ÎÒ´óÌåÒâ˼£¬
¶Áȡһ¸öͳ¼ÆÏµÍ³ÖÐ ²»Öظ´µÄ IP °´ÕÕ ×îºóʱ¼äÅÅÐò£¬²¢ÏÔʾ³öËùÓÐ×ֶΡ£¡ ......

sql Óï¾ä

±íA
¿¨ºÅ         ʱ¼ä
1                 null
2                 null
3 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ