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

BuildQuery A Simple SQL Query Tool

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace BuildQuery
{
/// <summary>
/// ʹÓÃÌṩµÄÊý¾Ý½¨Á¢Ò»¸öSQL²éѯ
/// </summary>
public class BuildQuery
{
#region ÀàµÄ±äÁ¿
int numFieldsCount, dispos; //×Ö¶ÎÊýÁ¿£¬¼Ç¼¶ººÅµÄÊýÁ¿
//
//½«ËùÓеÄ×ֶκÍÖµ·ÅÈëµ½Dictionary¼¯ºÏÀÌá¸ß²Ù×÷ЧÂÊ
//
Dictionary<string, string> dicFields = new Dictionary<string, string>(); //×ֶμ¯ºÏ
Dictionary<string, string> dicData = new Dictionary<string, string>(); //ÖµµÄ¼¯ºÏ
Dictionary<string, bool> dicQuotes = new Dictionary<string, bool>(); //ÊÇ·ñÐèÒªÒýºÅµÄ¼¯ºÏ
//
//Ìõ¼þ×ֶμ°ÖµµÄ¼¯ºÏ
//
List<string> listIDFields = new List<string>(); //×ֶμ¯ºÏ
List<string> listIDValues = new List<string>(); //ÖµµÄ¼¯ºÏ
List<bool> listIDQuotes = new List<bool>(); //ÒýºÅ¼¯ºÏ
List<string> listIDOperators = new List<string>();//²Ù×÷·û¼¯ºÏ

string strTable; //±íÃû
Boolean IdentityCheck; //ÊÇ·ñÐèÒª·µ»ØÒ»¸öеÄʵÌåÀà
/// <summary>
/// ·â×°Ò»¸öÊÇ·ñÐèҪеÄʵÌåÀà
/// </summary>
public Boolean GetIdentity
{
get { return IdentityCheck; }
set { IdentityCheck = value; }
}

/// <summary>
/// ·â×°·µ»ØÒ»¸ö²éѯµÄ½á¹û
/// </summary>
public string Table
{
get { return strTable; }
set { strTable = value; }
}
#endregion
/// <summary>
/// ÀàµÄʵÀý»¯¹¹Ôì·½·¨
/// </summary>
public BuildQuery()
{
}
/// <summary>
/// ½¨Á¢Ò»¸ö²éѯǰÇå³ýDICTIONARY¼¯ºÏµÄËùÓÐÄÚÈÝ
/// </summary>
publ


Ïà¹ØÎĵµ£º

SQL DROP TABLEµÄÓ÷¨

ÓÐʱºòÎÒÃÇ»á¾ö¶¨ÎÒÃÇÐèÒª´ÓÊý¾Ý¿âÖÐÇå³ýÒ»¸ö±í¸ñ¡£ÊÂʵÉÏ£¬Èç¹ûÎÒÃDz»ÄÜÕâÑù×öµÄ»°£¬Äǽ«»áÊÇÒ»¸öºÜ´óµÄÎÊÌ⣬ÒòΪÊý¾Ý¿â¹ÜÀíʦ (Database Administrator -- DBA) ÊÆ±ØÎÞ·¨¶ÔÊý¾Ý¿â×öÓÐЧÂʵĹÜÀí¡£»¹ºÃ£¬SQL ÓÐÌṩһ¸ö DROP TABLEµÄÓï·¨À´ÈÃÎÒÃÇÇå³ý±í¸ñ¡£ DROP TABLE µÄÓï·¨ÊÇ£º
DROP TABLE "±í¸ñÃû"
ÎÒÃÇÈç¹ûÒªÇå³ ......

JavaÁ¬½ÓSQL Server 2000

Êý¾Ý¿â²Ù×÷ÏÖÔÚÊÇÏîÄ¿¿ª·¢µÄ¸ù±¾£¬Ñ§Ï°JavaÊ×ÏÈÓ¦¸Ãѧ»áÔõôÑùÁ¬½ÓÊý¾Ý¿â£¬ÓÃJavaÁ¬½ÓÊý¾Ý¿â¿É²»ÏñÓÃDelphiÕâÀ๤¾ßÄÇÑùÉ輸¸öÊôÐÔ¾ÍOK£¬Ëµ¼òµ¥Ò²¼òµ¥£¬Ëµ¸´ÔÓ£¬ÆäʵҲͦ¸´Ôӵ쬶øÇÒºÜÂé·³£¬Èç¹ûÊdzõѧ£¬¸ù±¾²»Äܱ£Ö¤µÚÒ»´Î¾ÍÁ¬½Ó³É¹¦£¬ÏÂÃæÒÔSQL Server 2000ΪÀý£¬ËµËµJavaÁ¬½ÓÊý¾Ý¿âµÄ»ù±¾·½·¨£¬Ò²¼Ç¼һÏÂÐĵá£
1¡¢Ï ......

C# »ñÈ¡ SQL·þÎñÆ÷Áбí

#region   µÃµ½ËùÓб¾µØÍøÂçÖпÉʹÓõÄSQL·þÎñÆ÷ÁÐ±í  
  ///   <summary>  
  ///   µÃµ½ËùÓб¾µØÍøÂçÖпÉʹÓõÄSQL·þÎñÆ÷ÁÐ±í  
  ///   </summary>  
  ///   <param   name="p_strServerList">·þÎñÆ÷Áбí</param& ......

sqlÓï¾ä µÃµ½ sql server ±íÖÐÁеÄÀàÐͺÍ˵Ã÷

ͨ¹ýSqlÓï¾ä»ñµÃ ÁеÄÀàÐͺÍ˵Ã÷:
  µÃµ½µÄ±íÍ·£º±íÃû|ÁÐÃû|ÀàÐÍ|˵Ã÷
  1£ºÕë¶Ôsql server 2000£¬ÔÚsql2000ÖУ¬Ê¹Óãºsysobjects,syscolumnsºÍsysproperties±í
    SELECT o.name as table_name,c.name AS col_name,type_name(c.xtype) AS type_name,isnull(p.value,'') AS col_Pro ......

ÈçºÎдÓÐЧÂʵÄSQL²éѯ


[×ªÔØ]http://www.cnblogs.com/cn_wpf/£¬·Ç³£¸ÐлNineteen@newsmth µÄ·Ö·ÖÏí¡£ 
дÓÐЧÂʵÄSQL²éѯ£¨I£©
´óÐÍϵͳµÄÉú²ú»·¾³£¬Ò»°ãÇé¿öÏ£¬ÎÒÃÇÆÀ¼ÛÒ»Ìõ²éѯÊÇ·ñÓÐЧÂÊ£¬¸ü¶àµÄÊǹØ×¢Âß¼­IO(ÖÁÓÚΪʲô£¬»ØÍ·²¹Ò»Æª)¡£ÎÒÃdz£Ëµ£¬“Òª½¨±ëº·µÄË÷Òý”¡¢“Ҫд¸ßЧµÄSQL”£¬Æäʵ×îÖÕÄ¿µÄ¾ÍÊÇÔÚÏà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ