sql 2008 express
´ó¼ÒºÃ£¬
ÎÒÃǹ«Ë¾ÓõÄÊÇsql 2008 expressÊý¾Ý¿â¡£
ÒòΪ»ú×ÓÅäÖõ;Íûװsql2008£¬ÏÖÔÚÎÒÏëÕÒÒ»¸ö¹¤¾ßÄܹ»´ò¿ªsql 2008µÄ.mdfÎļþÀ´¿´ÀïÃæµÄÄÚÈÝ£¬¶ø²»ÏëÔÚvsÀï²é¿´¡£
ÇëÎÊ´ó¼ÒÓÐûÓкõŤ¾ß»òÊǰ취£¿Ð»Ð»£¡
http://hi.csdn.net/space-55860.html
ÄãÈ¥ÕÒϰÉ,Õâ¸öÈËËû×Ô¼ºÐ´Á˸ö²é¿´SQLµÄ¹¤¾ß,ͦºÃµÄ
ѧϰ
Õâ²»ÊÇËûµÄ¿Õ¼äµØÖ·Âð£¿ÓоßÌåµãµÄÂð£¿
Ã²ËÆÃ»ÕÒµ½............
ÕæÓÐÇ¿ÈËд³öÄÜÖ±½Ó¿´mdfÎļþµÄ¶«¶«À´ÁË?
²»Ò»¶¨ÊÇ×Ô¼ºÐ´µÄ£¬ÓÐûÓÐʲôÏֳɵŤ¾ß°¡£¿
±ÈÈç˵΢ÈíÓÐûÓз¢²¼Ïà¹ØµÄ¹¤¾ß°¡£¿»òÊÇsql2005Ҫװһ¸öʲô²å¼þ¾Í¿ÉÒÔ²éѯsql2008Êý¾Ý¿âµÄ¶«Î÷ÁË£¿
Ôõô¿ÉÄÜÖ±½Ó¶ÁmdfÎļþ,ÄÇÑùµÄ»°Î¢Èí³öSQL SERVER¸ÉÂï=.=!
ÓôÃÆ£¬ÎÒ»¹ÊÇ×°sql2008Õýʽ°æ°É
Ïà¹ØÎÊ´ð£º
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
Ò»Õűítable×Ö¶ÎF1ºÍF2
F1 F2
1 a
2 ......