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

sqlserver ÈçºÎµ÷ÊÔ´æ´¢¹ý³Ì

sqlserverÓÐûÓÐÏóoracleÄÇÑù¿ÉÒÔtest´æ´¢¹ý³Ì ,µ¥²½µ÷ÊÔ.²»Ó¦¸ÃûÓаÑ,ÎÒÔõôûÕÒµ½ÄØ? Òª²»È»ÉÔ΢³¤µãµÄ´æ´¢¹ý³ÌÔõôµ÷ÊÔÄØ?
ºÃÏóûÓÐ.

ûÓаÉ

ÓУ¬²éѯ·ÖÎöÆ÷ÖÐÓÒ¼ü´æ´¢¹ý³Ì£¬µ¥²½µ÷ÊÔ

°Ù¶ÈÉÏÈ¥ÕÒһϣ¡²»ÖªµÀ2008ÓÐûÓУ¡ºÃÏñÓиöʲôµÄ£¡

ÎÒÓõÄÊÇsql2005

²éѯ·ÖÎöÆ÷Àï²»ÊÇÓÐ µ÷ÊԵIJÙ×÷?

SQLµ÷ÊÔ¹¦Äܻҳ£²î ²»½¨ÒéʹÓÃ~

´ò¿ª²éѯ·ÖÎöÆ÷--¹¤¾ß--¶ÔÏóä¯ÀÀÆ÷--ÏÔʾ--ÔÚ¶ÔÏóä¯ÀÀÆ÷´°¿ÚÕÒµ½Òªµ÷ÊԵĴ洢¹ý³Ì--ÓÒ¼ü--µ÷ÊÔ¡£

ÒÔÉÏÊÇSQL SERVER2000µÄµ÷ÊÔ

Æäʵ×Ô¼º¼Ó¶àµãprint log²ÅÊÇ×îºÃµÄ
²»¹ýÓÃstudio.net ¿ÉÒÔµ÷ÊԵģ¬ÍøÉϺܶà½Ì³Ì

Ò»¶ÎÒ»¶Î´úÂëÊÖ¶¯Ö´ÐУ¬×¢ÒâÇ°ÃæÖ´ÐеĽá¹û¡¢±äÁ¿¡¢ÁÙʱ±í

SQL2005²»´ø´æ´¢¹ý³Ìµ÷ÊÔ¹¦ÄÜÁË
±ØÐë°²×°VS2005ÆóÒµ°æ»òÕß¿ª·¢°å£¬ÓÃVSSµÄµ÷ÊÔ¹¦Äܵ÷ÊÔ
SQL2008ÓÖ¼Ó½øÈ¥µ÷ÊÔ¹¦ÄÜÁË£¬²»¹ýʹÓñȽÏÂé·³¡£

ºÃÏñûÓÐ

ûÌý˵ÓÐ


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

sqlserver°²×°²»ÉÏ

ÎҵĵçÄÔ֨װÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔǰ°²×°µÄsqlserver Îļþ¡£ÖØ×°ÏµÍ³ºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿

ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿

ÄѵÀ¾µÏ ......

°ÑÒ»¸ösqlserverÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......

sqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°

±ÈÈç Óû§Ãû£¬ÎÒ³ÌÐòµÄÒªÇóÊÇ10λ×Ö·ûÒÔÄÚ£¬ËùÒÔ£º
Èç¹ûÎÒsqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°£¬

1.»á²»»á¼õÉÙÊý¾Ý¿Õ¼ä£¿
2.»á²»»áÌá¸ßÎÒ³ÌÐòµÄЧÂÊ£¿
3.ÓÐûÓбØÒª£¿

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