¹ØÓÚSQL 2008
Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£
лл£¡
ÎÒÒ²ÓÃ2000
1.Ì«¶àÁË ×Ô¼ºÈ¥²éÏÂ
2.¿ÉÒÔ
3.ѸÀ×
²¹³ä: 2000µÄSQL½Å±¾£¬ÔÚ2008ÖÐÄÜÓÃÂð£¿
ÄÜÓÃ
ÓÐһЩ²»¿ÉÒÔÓà ÓÐЩ¿ÉÒÔÓà Ҫ¿´ÏòϼæÈÝÐÔµÄÎÊÌâ
СF²»É¢·Ö???¹§Ï²¹þ
?ΪʲôҪɢ·Ö£¿
ÖÜδÊÔÊÔ¡£¡£¡£Ð»Ð»
ÉýÐÇѽ,ºÇºÇ,
ÎÒ»¹Ê¹ÓõÄÊÇsqlserver2000ÄØ
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
Çë°ïæ¿´¿´ÔõôÓÅ»¯Ò»Ï£¬¸Ã±íÊý¾ÝԼΪ66Íò£¬ÔËÐÐʱ¼äÒª19Ãë,SQLÈçÏ£º
select DATEPART (hh ,Date_time ) as Hours ,
sum(Counts)*100.0/(Select sum(Counts) as total
&nbs ......
ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡
SQL2005 µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)
Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......
ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í
a±í:
¹¤ºÅ ÐÕÃû ËùÊô²¿ÃűàºÅ
001 A
002 B
003&n ......
ÎÒÏÖÔÚÓÐ2¸ö±íTable1£¬Table2¡£¶ÔÓ¦µÄ×ֶΡ¢Êý¾ÝÈçÏ£º
Table1£ºprimary key(a1)
a1(char) a2(int)
a 10
b & ......