Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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())
            {
    


Ïà¹ØÎĵµ£º

ms sql´æ儲過³Ì參數·µ»ØÖµ

create table tabReProc
 (    
 name varchar(30),    
 age integer,    
 primary key(name,age)    
 ) 
 insert into tabReProc values('x7700',20) 
 insert into tabR ......

SQlÊý¾Ý¿â¿ìËÙÈëÃűØÐëÕÆÎÕµÄËÄ´ó»ù±¾Óï¾ä

×öÒ»¸öϵͳµÄºǫ́£¬»ù±¾É϶¼ÉÙ²»ÁËÔöɾ¸Ä²é£¬×÷Ϊһ¸öÐÂÊÖÈëÃÅ£¬ÎÒÃDZØÐëÒªÕÆÎÕSQLËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä£ºInsert£¬Select£¬UpdateºÍDelete£¡ ÏÂÃæ¶ÔÕâËĸöÓï¾ä½øÐÐÏêϸµÄÆÊÎö£º
¡¡¡¡ ÊìÁ·ÕÆÎÕSQLÊÇÊý¾Ý¿âÓû§µÄ±¦¹ó²Æ¸»¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Òýµ¼ÄãÕÆÎÕËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä—SQLµÄºËÐŦÄÜ—À´ÒÀ´Î½éÉܱȽ ......

ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼

ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼
ÎÄÕÂÀ´×Ô£ºhttp://www.cnblogs.com/lindayyh/archive/2010/04/05/1704763.html
ÔÚÎÒÃÇ¿ª·¢ÉÌÎñÈí¼þµÄʱºò£¬³£³£»áÓöµ½ÕâÑùµÄÒ»¸öÎÊÌ⣺ÔõÑù·ÀÖ¹Óû§Öظ´µÇ¼ÎÒÃǵÄϵͳ£¿ÌرðÊǶÔÓÚÒøÐлòÊDzÆÎñ²¿ÃÅ£¬¸üÊÇÒªÏÞÖÆÓû§ÒÔÆä¹¤ºÅÉí·Ý¶à´ÎµÇÈë¡£
¿ÉÄÜ»áÓÐÈË˵ÔÚÓû§ÐÅÏ¢±íÖмÓÒ»×Ö¶ÎÅÐ ......

sql»ù±¾Óï¾ä

/*********************************************************/
Ŀ¼Çåµ¥CONTEXT LIST
/*********************************************************/
1.Êý¾Ý¿âDataBase
1.1Êý¾Ý¿â½¨Á¢/ɾ³ýcreate/drop database
1.2Êý¾Ý¿â±¸·ÝÓë»Ö¸´backup/restore database
/***************************************************** ......

ÍøÕª£­SQL Server 2008 Êý¾Ý¿âÈÕÖ¾Çå³ýÃüÁî

 USE [master]
    GO
    ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT
    GO
    ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE
    GO
    USE [Database_Name]
  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ