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

Îʼ¸¸ö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£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£

ÒýÓÃ
1.Èç¹ûÄãÒªÉÌÓ㬽¨ÒéMySql°É£¬±Ï¾¹Ãâ·Ñ£¬Èç¹ûÓõÁ°æMS-SQL£¬±»²éµ½¾ÍÍæÍêÁË¡£µ±È»Ð¡´òСÄÖ¾ÍÎÞËùνÁË¡£
2.Äã¿ÉÒÔ¼Ù×°ÒªÂòSQL2008£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£

¼Ù×°ÒªÂò

ÒýÓÃ
1.Èç¹ûÄãÒªÉÌÓ㬽¨ÒéMySql°É£¬±Ï¾¹Ãâ·Ñ£¬Èç¹ûÓõÁ°æMS-SQL£¬±»²éµ½¾ÍÍæÍêÁË¡£µ±È»Ð¡´òСÄÖ¾ÍÎÞËùνÁË¡£
2.Äã¿ÉÒÔ¼Ù×°ÒªÂòSQL2008£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£

¹µÐÖ£¬»¹ÊDz»ÌÖÂÛÊÇ·ñÕý°æµÄÕâ¸öÎÊÌâ°É¡£

ÎÒµÄÒâ˼ÊÇ£¬sql2008³öÁËsp1ÁË£¬Õýʽ²¿ÊðÏîÄ¿ÉÏÓ¦¸ÃûÎÊÌâÁ˰ɣ¿


Ïà¹ØÎÊ´ð£º

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ