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

sqlÁ¬½Ó´úÂë


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
namespace WebApplication1
{
   public class Message
    {
        public static IList<MessageInfo> GetMessages()
        {
            IList<MessageInfo> msgs = new List<MessageInfo>();//×Ô¶¨ÒåÁôÑÔʵÌåµÄ¼¯ºÏ
            //´ÓÅäÖÃÎļþÖлñÈ¡Á¬½Ó×Ö·û´®
            string connstr = WebConfigurationManager.ConnectionStrings["GuestBookDBConnectionString"].ConnectionString;
            //´´½¨Á¬½Ó¶ÔÏó
            SqlConnection conn = new SqlConnection(connstr);
            //´´½¨ÃüÁî¶ÔÏó
            SqlCommand cmd = new SqlCommand("select * from MsgInfo", conn);
            //´ò¿ªÊý¾Ý¿âÁ¬½Ó
            conn.Open();
            //Ö´ÐÐÃüÁî¶ÔÏóÖеÄsqlÃüÁ»ñÈ¡Êý¾Ý
            //×¢ÒâdatareaderµÄÌØµã£¬Ö»¶Á£¬Ïòǰ£¬Ã¿´ÎÒ»Ìõ¼Ç¼¡£
            SqlDataReader dr = cmd.ExecuteReader();
            //Ñ­»·¶ÁÈ¡Êý¾Ý¿â¼Ç¼£¬Ã¿´ÎÒ»ÐÐ
            while (dr.Read())
            {
    


Ïà¹ØÎĵµ£º

SQL ³£ÓÃÓï¾ä

(1)Êý¾Ý¼Ç¼ɸѡ£º
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃû=×Ö¶ÎÖµorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûlike'%×Ö¶ÎÖµ%'orderby×Ö¶ÎÃû[desc]"
sql="selecttop10*fromÊý¾Ý±íwhere×Ö¶ÎÃûorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûin('Öµ1','Öµ2','Öµ3')"
sql="select*fromÊý¾Ý±íwhere× ......

SQL¿ç·þ²éѯ

½ñÈÕ²úÆ·²¿Òªµ¼ÅúÊý¾Ý£¬µ«ÊÇÐèÒªÁ¬½Ó²éѯ²éѯµÄ¼¸¸ö±í²»ÔÚͬһ·þÎñÆ÷ÉÏ¡£ËùÒÔÎÒ¿ªÊ¼ÊÇÕâô¸ÉµÄ£º
1.²éѯһ̨·þÎñÆ÷µÄÊý¾Ý£¬²¢µ¼Èë±¾µØExcel
2.²éѯÁíһ̨·þÎñÆ÷µÄÊý¾Ý£¬²¢µ¼Èë±¾µØExcel
3.Excleµ¼ÈëÊý¾Ý¿â£¬Êý¾Ý¿â×Ô´øÁËExcelµ¼ÈëÊý¾Ý¿âµÄ¹¦ÄÜ
4.Á¬½Ó²éѯ£¬OVER£¡
ºóÀ´²ÅÖªµÀ²úÆ·²¿ÒªÈ«¹ú50¶à¸ö³ÇÊеÄÊý¾Ý£¬ËùÒÔÿ¸ö³Ç ......

OracleÖÐSQL±àд¼¯½õ

1¡¢ÊµÏÖÐÐÁж¯Ì¬×ª»»£¬³£ÓÃÓÚÖ÷´Ó±í¹ØÁªÊ±µÄÌØÊâÐèÇó
select rwbm,psqh,
           max(decode(xh1,1,yy))JKYL1,
           max(decode(xh1,2,yy))JKYL2,
        &n ......

Ãâ·ÑµÄSQL Server¹¤¾ß¿ÉÄÜÈÃÄãµÄÉú»î±äµÃ¸üÇáËÉ

¸üУºÐµĶ«Î÷´Ó×îеĸüн«ÊǺìÉ«µÄ¡£
This list will grow as I find new tools.Õâ·ÝÃûµ¥½«³É³¤ÎªÎÒÕÒµ½ÐµĹ¤¾ß¡£ So if you know of some not on this list do post them in the comments.ËùÒÔ£¬Èç¹ûÄãÖªµÀһЩ²»ÔÚ´ËÃûµ¥ÖеÄÒâ¼ûºó×öËûÃÇ¡£
SQL Server Management Studio Add-in's SQL Server¹ÜÀí¹¤×÷ÊÒÍâ½ÓµÄ
......

sql server Êý¾Ý¿âµ¼ÈëÎÊÌâ

ÓÉÓÚÍøÕ¾ÊDZðÈ˵Ä
sql server  2000 ²»Äܵ¼Èë2005 µÄÊý¾Ý¿âÎļþ ÎÒÖ»ºÃ°´ÕÕÊéÉÏÖØÐ½¨Á¢µÄÊý¾Ý¿âÎļþ
È»ºóÔÚvisual studio 2005ÖÐÒ»¸öÒ»¸öµÄ¸´ÖÆ´æ´¢¹ý³Ìµ½sql server 2000
ÕâÑù¾Í²»ÓÃÏÂÔØ sql server 2005 ÁË
Èç¹ûÓÐsql server 2005 µÄ»°Ö®¼ÊÉú³É ½Å±¾¾ÍÒ»ÖÂÐÔµ¼Èë¾ÍokÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ