´ó¼Ò¶¼ÓÃʲô¹¤¾ß±àдSqlÓï¾ä°¡£¿
ÓÐûÓÐÏósqlserver²éѯ·ÖÎöÆ÷ÒªºÍÆóÒµ¹ÜÀíÆ÷Ò»ÑùµÄ¹¤¾ß¡£»¹ÓÐʲôÆäËûµÄsql±à¼¹¤¾ßÂð£¿
´ó¼Ò¶Ô ÏÖÔÚµÄsql±à¼¹¤¾ß»¹ÓÐʲôҪÇóºÍ²»ÂúÒâµÄµØ·½Âð£¿Ëµ³öÀ´¿´¿´¡£
ºÇºÇ£¬ÆäʵÊÇÏëд¸öÈí¹ã¸æ¡£¿ÉÊÇʵÔÚ²»»á´ë´Ç¡£
˵ʵ»°°É£¬Ð´Á˸ösql±à¼¹¤¾ß¡£×ÔÎҸоõÁ¼ºÃ£¬»¶Ó´ó¼Ò¸øµãÒâ¼û¡£ÎÒ¾¡Á¦È¥°Ñ´ó¼ÒµÄÏ뷨ʵÏÖ£¬Ð»Ð»£¡
Èí¼þÃû³Æ£ºSqlEditPlugs
ÏÂÔØµØÖ·£ºhttp://218.25.154.154:8081/Software/SqlEditPlugs.rar
=====================================================================================================
ÆÁ±ÎÊý¾Ý¿â¼äµÄ²îÒ죬ÒÔͳһµÄ½çÃæºÍ²Ù×÷·½Ê½À´¶ÔÊý¾Ý½øÐд¦Àí£¬½«³ÌÐòÔ±»òÊý¾Ý¹ÜÀíÔ±´Ó·±ËöµÄ²Ù×÷ģʽÖнâÍѳöÀ´£¬Ê¹Æä¸ü¼ÓרעµÄ½øÐÐ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¡¢¿ç¿â²Ù×÷£º¿Éͬʱ¿ç¶à¸öÊý¾Ý¿â¼ä²Ù×÷£¬»¥²»Ó°Ïì¡£ËæÊ±Çл»£¬ËæÊ±ÔËÐС£
5¡¢ËæÒâÔËÐУºÔËÐÐÑ¡ÔñµÄ´úÂë¡¢ÔËÐжà¸öSq
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......