sqlserver ÈçºÎµ÷ÊÔ´æ´¢¹ý³Ì
sqlserverÓÐûÓÐÏóoracleÄÇÑù¿ÉÒÔtest´æ´¢¹ý³Ì ,µ¥²½µ÷ÊÔ.²»Ó¦¸ÃûÓаÑ,ÎÒÔõôûÕÒµ½ÄØ? Òª²»È»ÉÔ΢³¤µãµÄ´æ´¢¹ý³ÌÔõôµ÷ÊÔÄØ?
ºÃÏóûÓÐ.
ûÓаÉ
ÓУ¬²éѯ·ÖÎöÆ÷ÖÐÓÒ¼ü´æ´¢¹ý³Ì£¬µ¥²½µ÷ÊÔ
°Ù¶ÈÉÏÈ¥ÕÒһϣ¡²»ÖªµÀ2008ÓÐûÓУ¡ºÃÏñÓиöʲôµÄ£¡
ÎÒÓõÄÊÇsql2005
²éѯ·ÖÎöÆ÷Àï²»ÊÇÓÐ µ÷ÊԵIJÙ×÷?
SQLµ÷ÊÔ¹¦Äܻҳ£²î ²»½¨ÒéʹÓÃ~
´ò¿ª²éѯ·ÖÎöÆ÷--¹¤¾ß--¶ÔÏóä¯ÀÀÆ÷--ÏÔʾ--ÔÚ¶ÔÏóä¯ÀÀÆ÷´°¿ÚÕÒµ½Òªµ÷ÊԵĴ洢¹ý³Ì--ÓÒ¼ü--µ÷ÊÔ¡£
ÒÔÉÏÊÇSQL SERVER2000µÄµ÷ÊÔ
Æäʵ×Ô¼º¼Ó¶àµãprint log²ÅÊÇ×îºÃµÄ
²»¹ýÓÃstudio.net ¿ÉÒÔµ÷ÊԵģ¬ÍøÉϺܶà½Ì³Ì
Ò»¶ÎÒ»¶Î´úÂëÊÖ¶¯Ö´ÐУ¬×¢ÒâÇ°ÃæÖ´ÐеĽá¹û¡¢±äÁ¿¡¢ÁÙʱ±í
SQL2005²»´ø´æ´¢¹ý³Ìµ÷ÊÔ¹¦ÄÜÁË
±ØÐë°²×°VS2005ÆóÒµ°æ»òÕß¿ª·¢°å£¬ÓÃVSSµÄµ÷ÊÔ¹¦Äܵ÷ÊÔ
SQL2008ÓÖ¼Ó½øÈ¥µ÷ÊÔ¹¦ÄÜÁË£¬²»¹ýʹÓñȽÏÂé·³¡£
ºÃÏñûÓÐ
ûÌý˵ÓÐ
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÎҵĵçÄÔ֨װÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔǰ°²×°µÄsqlserver Îļþ¡£ÖØ×°ÏµÍ³ºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿
ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿
ÄѵÀ¾µÏ ......
Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ
C# code:
private void connserver()
{
Cursor.Current = Cursors.WaitCursor;
try
{
......
±ÈÈç Óû§Ãû£¬ÎÒ³ÌÐòµÄÒªÇóÊÇ10λ×Ö·ûÒÔÄÚ£¬ËùÒÔ£º
Èç¹ûÎÒsqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°£¬
1.»á²»»á¼õÉÙÊý¾Ý¿Õ¼ä£¿
2.»á²»»áÌá¸ßÎÒ³ÌÐòµÄЧÂÊ£¿
3.ÓÐûÓбØÒª£¿
СµÜÏÈл ......