Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÓÅ»¯ÇóÖú

Çë°ïæ¿´¿´ÔõôÓÅ»¯Ò»Ï£¬¸Ã±íÊý¾ÝԼΪ66Íò£¬ÔËÐÐʱ¼äÒª19Ãë,SQLÈçÏ£º

select DATEPART (hh ,Date_time ) as Hours ,
sum(Counts)*100.0/(Select sum(Counts) as total
      &nbs ......

¾Ý˵SQLÓиö±à¼­Æ÷£¬²»ÖªÈçºÎʹÓ÷¨£¬ÔÚʲôµØ·½£¿

ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼­Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡

SQL2005  µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)

Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......

ÇóSQLÓï¾ä

ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í

a±í:
¹¤ºÅ  ÐÕÃû  ËùÊô²¿ÃűàºÅ
001              A
002              B
003&n ......

ÇóSQLÓï¾äµÄд·¨

ÎÒÏÖÔÚÓÐ2¸ö±íTable1£¬Table2¡£¶ÔÓ¦µÄ×ֶΡ¢Êý¾ÝÈçÏ£º

Table1£ºprimary key(a1)
a1(char)      a2(int)
  a            10
  b  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ