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

sql 2008 express

´ó¼ÒºÃ£¬
ÎÒÃǹ«Ë¾ÓõÄÊÇsql 2008 expressÊý¾Ý¿â¡£
ÒòΪ»ú×ÓÅäÖõ;Íûװsql2008£¬ÏÖÔÚÎÒÏëÕÒÒ»¸ö¹¤¾ßÄܹ»´ò¿ªsql 2008µÄ.mdfÎļþÀ´¿´ÀïÃæµÄÄÚÈÝ£¬¶ø²»ÏëÔÚvsÀï²é¿´¡£
ÇëÎÊ´ó¼ÒÓÐûÓкõŤ¾ß»òÊǰ취£¿Ð»Ð»£¡
http://hi.csdn.net/space-55860.html

ÄãÈ¥ÕÒϰÉ,Õâ¸öÈËËû×Ô¼ºÐ´Á˸ö²é¿´SQLµÄ¹¤¾ß,ͦºÃµÄ

ÒýÓÃ
http://hi.csdn.net/space-55860.html

ÄãÈ¥ÕÒϰÉ,Õâ¸öÈËËû×Ô¼ºÐ´Á˸ö²é¿´SQLµÄ¹¤¾ß,ͦºÃµÄ

ѧϰ

Õâ²»ÊÇËûµÄ¿Õ¼äµØÖ·Âð£¿ÓоßÌåµãµÄÂð£¿

ÒýÓÃ
http://hi.csdn.net/space-55860.html

ÄãÈ¥ÕÒϰÉ,Õâ¸öÈËËû×Ô¼ºÐ´Á˸ö²é¿´SQLµÄ¹¤¾ß,ͦºÃµÄ


Ã²ËÆÃ»ÕÒµ½............

ÕæÓÐÇ¿ÈËд³öÄÜÖ±½Ó¿´mdfÎļþµÄ¶«¶«À´ÁË?

²»Ò»¶¨ÊÇ×Ô¼ºÐ´µÄ£¬ÓÐûÓÐʲôÏֳɵŤ¾ß°¡£¿

±ÈÈç˵΢ÈíÓÐûÓз¢²¼Ïà¹ØµÄ¹¤¾ß°¡£¿»òÊÇsql2005Ҫװһ¸öʲô²å¼þ¾Í¿ÉÒÔ²éѯsql2008Êý¾Ý¿âµÄ¶«Î÷ÁË£¿

ÒýÓÃ
±ÈÈç˵΢ÈíÓÐûÓз¢²¼Ïà¹ØµÄ¹¤¾ß°¡£¿»òÊÇsql2005Ҫװһ¸öʲô²å¼þ¾Í¿ÉÒÔ²éѯsql2008Êý¾Ý¿âµÄ¶«Î÷ÁË£¿


Ôõô¿ÉÄÜÖ±½Ó¶ÁmdfÎļþ,ÄÇÑùµÄ»°Î¢Èí³öSQL SERVER¸ÉÂï=.=!

ÓôÃÆ£¬ÎÒ»¹ÊÇ×°sql2008Õýʽ°æ°É


Ïà¹ØÎÊ´ð£º

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......

ÇóÒ»¸ösqlÎĵÄд·¨

Ò»Õűítable×Ö¶ÎF1ºÍF2

F1    F2
1    a                               
2    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ