jspÓëSQL Server 2000 µÄÁ¬½Ó
ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
Ç°¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔÇ°µÄ¾Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½ÎÒµÄѸÀײ©¿Í×ÊÔ´ÄÇÀïÈ¥ÏÂÔØ£º
http://317225483.blog.xunlei.com/index.html£¬×¨¼ÃûΪ£ºSQL Server 2000£¬ÏÂÄǸöSQL°²×°³ÌÐò£¬»¹ÐèÏÂÔØSQL Server 2000µÄ²¹¶¡SQL2000-KB884525-SP4-x86- CHS.EXEºÍSQL Server 2000 driver for JDBC¡£
2¡¢°²×°SQL Server 2000£¬°²×°¹ý³ÌÖÐÐèҪעÒâµÄµØ·½ÈçÏ£º
ÔËÐÐpersonalĿ¼ÏµÄAutorun.exeÎļþ»òÆäËü¿ÉÖ´ÐÐÎļþ£¬µ÷³ö°²×°³ÌÐòºó£¬³öÏÖÉÏͼËùʾ½çÃ档ѡÔñ“±¾µØ¼ÆËã»ú”ºó£¬µã»÷“ÏÂÒ»²½”¡£
Ñ¡´´½¨ÐµÄSQL ServerʵÀý……”£¬µãÏÂÒ»²½
Ñ¡ÖГ·þÎñÆ÷ºÍ¿Í»§¶Ë¹¤¾ß”£¬µãÏÂÒ»²½
×¢ÒâÉÏͼÕâÀï±È½Ï¹Ø¼ü£¬Éí·ÝÑé֤ѡÔñ“»ìºÏģʽ”£¨ÉÏͼ£©¡£Çë×¢Ò⣬saµÄµÇ¼ÃÜÂëÓëWindoesµÄµÇ¼ÃÜÂë²»ÄÜÏàͬ¡£Èç³öÏÖÏàͬ£¬Èí¼þÔòÎÞ·¨Á¬½ÓÊý¾Ý¿â¡£saΪ¸ß¼¶Óû§Ãû£¬saµÄÃÜÂë¼´ÊÇÈí¼þµÄ³õʼÃÜÂë¡£
ºóÃæµÄ¾Í¿ÉÒÔĬÈÏ°²×°ÏÂÈ¥ÁË¡£
3¡¢°²×°SQL Server 2000²¹¶¡SQL2000-KB884525-SP4-x86- CHS.EXE£¬Ë«»÷ºó³öÏÖ
È»ºóһֱĬÈÏ°²×°¼´¿É£¬ÔÙµ½CÅ̵ÄSQL2KSP4Ŀ¼ÏÂÕÒµ½setup.bat£¬È»ºóË«»÷£¬È»ºóÒ»Ö±µ½ÕâÀïÑ¡Ôñ:
SQL Serverϵͳ¹ÜÀíÔ±.....,£¬ÊäÈëÄã¸Õ²Å°²×°SQL Server 2000ʱÉèÖõÄsaÃÜÂë
ÏÂÃæµÄ¾ÍOK À²£¡
4¡¢°²×°SQL Server 2000 driver for JDBCÇý¶¯£¬°ÑÏÂÔØÏÂÀ´µÄÄǸösetup.exeÖ±½ÓË«»÷ĬÈÏ°²×°¼´¿É¡£
5¡¢×îºóÕÒµ½°ÑC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\libϵÄmsbase.jar¡¢mssqlserver.jar¡¢msutil.jarÈý¸öÎļþ¸´ÖƵ½TomcatϵÄbinĿ¼ÏÂF:\tomcat-5.5.20\bin¡£
6¡¢ÏÖÔÚ¸ÃÊDzâÊÔһϵÄʱºòÁË£º´ò¿ªSQLµÄÆóÒµ¹ÜÀíÆ÷´´½¨Êý¾Ý¿âΪstudent£¬ÔÙн¨Ò»¸ö±ístu£¬È»ºóÌí¼Ó¼¸Ìõ¼Ç¼¡£Æô¶¯MyEclipse£¬Ð½¨JSPÎļþ£¬³ÌÐò´úÂë(ƽƽͬѧÄǸ´ÖÆÀ´µÄ£¬ºÇºÇ£¡ÕýÈ·µÄ£¡£¡)ÈçÏ£º
<%@page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html;charset=gb2312"%>
<html>
<bod
Ïà¹ØÎĵµ£º
¡¡Microsoft SQL server2000ÓÉһϵÁÐÏ໥Ð×÷µÄ×é¼þ¹¹³É¡£ÄÜÂú×ã×î´óµÄWEBÕ¾µãºÍÆóÒµÊý¾Ý´¦Àíϵͳ´æ´¢ºÍ·ÖÎöÊý¾ÝµÄÐèÒª¡£±¾ÎÄ´øÀ´µÄ¾ÍÊÇÔÚwindows»·¾³ÏÂSQL2000µÄ°²×°¹ý³Ì¡£
¡¡¡¡
¡¡¡¡ÏµÍ³ÐèÇó
¡¡¡¡
¡¡¡¡ÕâÀïÒÔÆäËĺÏÒ»°æ±¾ÎªÀý£¬ÒÔÏ°²×°¹ý³ÌͬÀí¡£Microsoft SQL Server 2000 ¿ÉÔÚÔËÐÐ Intel»ò¼æÈÝµÄ Pentium¡¢Pentium ......
SELECT LEFT(RTRIM('20080927p1058'),LEN('20080927p1058')-2)
SELECT SUBSTRING('20080927p1058',1,LEN('20080927p1058')-2)
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*whit ......
SQL Server 2005µÄжÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßжÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏжÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öÊ°빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØжÔع¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.mic ......
¹«¸æ£º±¾²©¿ÍΪ΢ÈíÔƼÆËãÖÐÎIJ©¿ÍµÄ¾µÏñ²©¿Í£¬²¢²»±£Ö¤Á´½Ó¿ÉÓÃÐÔ£¬ÎªÁ˱£Ö¤ÔĶÁÌåÑ飬Çë·ÃÎÊhttp://blogs.msdn.com/azchina¡£
SQL Azure vs. SQL Server
¸ÅÒª
SQL Azure Database ÊÇÒ»¸öÀ´×Ô΢ÈíµÄ£¬»ùÓÚÔƵĹØϵÐÍÊý¾Ý¿â·þÎñ¡£SQL Azure Ìṩ¹ØϵÐÍÊý¾Ý¿â¹¦ÄÜÀ´×÷Ϊ¹«Ó÷þÎñ¡£»ùÓÚÔƵÄÊý¾Ý¿â½â¾ö·½°¸ ......
Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔص½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ»µ¥¼Ç¼·Ö½âÔÙ×°Èëµ½± ......