´ó¼Ò¶¼ÓÃʲô¹¤¾ß±àдSqlÓï¾ä°¡£¿
ÓÐûÓÐÏósqlserver²éѯ·ÖÎöÆ÷ÒªºÍÆóÒµ¹ÜÀíÆ÷Ò»ÑùµÄ¹¤¾ß¡£»¹ÓÐʲôÆäËûµÄsql±à¼¹¤¾ßÂð£¿
´ó¼Ò¶Ô ÏÖÔÚµÄsql±à¼¹¤¾ß»¹ÓÐʲôҪÇóºÍ²»ÂúÒâµÄµØ·½Âð£¿Ëµ³öÀ´¿´¿´¡£
ºÇºÇ£¬ÆäʵÊÇÏëд¸öÈí¹ã¸æ¡£¿ÉÊÇʵÔÚ²»»á´ë´Ç¡£
˵ʵ»°°É£¬Ð´Á˸ösql±à¼¹¤¾ß¡£×ÔÎҸоõÁ¼ºÃ£¬»¶Ó´ó¼Ò¸øµãÒâ¼û¡£ÎÒ¾¡Á¦È¥°Ñ´ó¼ÒµÄÏ뷨ʵÏÖ£¬Ð»Ð»£¡
Èí¼þÃû³Æ£ºSqlEditPlugs
ÏÂÔØµØÖ·£ºhttp://218.25.154.154:8081/Software/SqlEditPlugs.rar
£¨·Ö˵ÓÐÏÞ£¬µÚÒ»¸öºÍ×îºóÒ»¸ö¸úÌûµÄÖ»Äܸ÷¸ø30·ÖÁË£©
=====================================================================================================
ÆÁ±ÎÊý¾Ý¿â¼äµÄ²îÒ죬ÒÔͳһµÄ½çÃæºÍ²Ù×÷·½Ê½À´¶ÔÊý¾Ý½øÐд¦Àí£¬½«³ÌÐòÔ±»òÊý¾Ý¹ÜÀíÔ±´Ó·±ËöµÄ²Ù×÷ģʽÖнâÍѳöÀ´£¬Ê¹Æä¸ü¼ÓרעµÄ½øÐÐSqlÓï¾äµÄ±àд¡£
½«²éѯ·ÖÎöÆ÷ºÍÆóÒµ¹ÜÀíÆ÷¹¦Äܺ϶þΪһ£¬²¢ÈÚÈëÖÚ¶àʵÓù¦ÄÜ£¬²¢ÍêÃÀÖ§³Ö sqlserver¡¢oracle¡¢mysql¡¢access¡£ÊÇÄú±àдsqlÓï¾äºÍÊý¾Ý·ÖÎöµÄ¾ø¼Ñ°ïÊÖ¡£
¹ÙÍøµØÖ·£º
http://www.i5iw.com
http://218.25.154.154:8081/
QQȺ £º88725010
E-Mail £ºl00f@163.com
¹¦ÄÜÁÐ±í£º
1¡¢´úÂë¸ßÁÁ£º¸ù¾Ý²Ù×÷Êý¾Ý¿âµÄ²»Í¬Çø·ÖÏàÓ¦¹Ø¼ü×Ö£¬²¢¸ßÁÁÏÔʾ
2¡¢×Ô¶¯Íê³É£ºÊäÈ벻ͬµÄ±íÃûµÈÐÅÏ¢£¬½«×Ô¶¯ÌáʾÏà¹ØµÄ×Ö¶ÎÐÅÏ¢µÈ¡£
3¡¢ÖÇÄÜÌáʾ£ºÊäÈëÏàÓ¦¹Ø¼ü×Ö½«³öÏÖÀàËÆVSÖÐÒ»ÑùµÄ˵Ã÷Ìáʾ¡£
4¡¢¿ç¿â²Ù×÷£º¿Éͬʱ¿ç¶à¸öÊý¾Ý¿â¼ä²Ù×÷£¬»¥²»Ó°Ïì¡£ËæÊ±Çл»£¬ËæÊ±ÔËÐС
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
set rs1=server.createobject("adodb.recordset")
sql1="select * from Task where ID='"&request("ID")&"'"
rs1.open sql1,conn,1,1
Notice=rs1 ......