Îʼ¸¸öSQL Server2008µÄÎÊÌâ
1£¬ÕýʽÉÌÒµÓ¦Óò¿ÊðSQL Server2008+SP1(x86 32bit)ÏÖÔÚÓ¦¸ÃûÎÊÌâÁ˰ɣ¿
2£¬Í¬ÑùµÄÓ²¼þÅäÖã¬sql2008ÊDz»ÊDZÈsql2005Õ¼×ÊÔ´£¿sql2008ÔËÐл᲻»á±Èsql2005Á÷³©£¿£¨vs2008¾Í±Èvs2005Á÷³©£©
3£¬sql2000µÄÊý¾Ý¿âÎļþ¿ÉÒÔÖ±½Ó¸½¼Óµ½sql2008ÉÏô£¿
¶àл´ó¼Ò¡£
2008
還沒ÓÐÓÃ過
1²»ÖªµÀÈçºÎ»Ø´ð
2²»ÖªµÀÈçºÎ»Ø´ð
3¿ÉÒÔ
sql2008ÓõıȽÏÉÙ£¿°ï¶¥£¡ÆÚ´ý¸ßÊÖ½â´ð
ºÃÏñÓÐÈ˲âÊÔ¹ý£¬Õý³£µÄDMLÐÔÄÜÉÏûÓжà´óµÄ¸Ä½ø¡£
µ«ÊÇÄãÔËÓÃһЩÐµĹ¦ÄܺÍÓï·¨¿Ï¶¨¿ÉÒÔÌá¸ßÐÔÄܵġ£
ûÓÐÓùý................
¼´ÊÇÕýʽÉÌÓã¬ÄǾÍÒªÂòÕý°æà¶£¿
ÕâЩÎÊÌâÍêÈ«¿ÉÒÔÓÉ΢Èí/»ò΢Èí´úÀí£¬À´¸ø³öרҵ»Ø´ð
¹µÐÖ£¬d°æµÄ¡£
ÕýʽÊÇÏà¶ÔÓÚ¸öÈËÊÔÓÃÀ´ËµµÄ¡£
1.Èç¹ûÄãÒªÉÌÓ㬽¨ÒéMySql°É£¬±Ï¾¹Ãâ·Ñ£¬Èç¹ûÓõÁ°æMS-SQL£¬±»²éµ½¾ÍÍæÍêÁË¡£µ±È»Ð¡´òСÄÖ¾ÍÎÞËùνÁË¡£
2.Äã¿ÉÒÔ¼Ù×°ÒªÂòSQL2008£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£
¼Ù×°ÒªÂò
¹µÐÖ£¬»¹ÊDz»ÌÖÂÛÊÇ·ñÕý°æµÄÕâ¸öÎÊÌâ°É¡£
ÎÒµÄÒâ˼ÊÇ£¬sql2008³öÁËsp1ÁË£¬Õýʽ²¿ÊðÏîÄ¿ÉÏÓ¦¸ÃûÎÊÌâÁ˰ɣ¿
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......