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

ÓÃC#¶ÁSQL SERVERµ½¿ØÖÆÌ¨µÄ¼òµ¥Ê¾Àý

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication4
{
class Program
{
static void Main(string[] args)
{
//sqlserverÉí·ÝÑéÖ¤
//string sqlconn = "server=(local);database=keede1228;user id=sa;password=123;";
//windowsÉí·ÝÑéÖ¤
string sqlconn = "server=(local);database=keede1228;integrated security=SSPI;";
string select = "select * from dbo.lmShop_City";
SqlConnection conn = new SqlConnection(sqlconn);
Console.WriteLine("33");
conn.Open();
Console.WriteLine("11");
SqlCommand cmd = new SqlCommand(select, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("cityid:{0} city:{1} area:{2}", reader[0], reader[1], reader[2]);
}
conn.Close();
Console.WriteLine("22");
Console.ReadKey();
}
}
}

ÓÐÒ»µãÒÉÎÊ£º×îºóÊä³öµ½¿ØÖÆÌ¨µÄʱºò£¬Èç¹û²»¼Ó"cityid:{0} city:{1} area:{2}"¾Í»á±¨´í£¬²»ÖªµÀÊÇΪʲô£¬ºÃÏñÊÇÀàÐÍת»»µÄÊ£¬ÓÐÃ÷°×µÄ°ïÎÒ½â´ðһϣ¬Ð»Ð»¡£


Ïà¹ØÎĵµ£º

asp.net(c#)´ÓCache¶ÔÏóɾ³ýÏѧϰÈռǶþ£©

ÉÏÆªÎÄÕÂÖÐ˵µ½Ê²Ã´ÊÇ Cache¶ÔÏó£¬ÈçºÎÔÚASP.NETÖÐʹÓà Cache¶ÔÏó¡£ÏÂÃæÎÒÃÇÀ´ËµËµÈçºÎÔÚASP.NETÖÐɾ³ýÏî¡£
ASP.NET Cache ¶ÔÏóÉè¼ÆÓÃÓÚ±£Ö¤Ëü²¢²»Ê¹Óùý¶àµÄ·þÎñÆ÷ÄÚ´æ¡£½á¹ûÊÇ£¬µ±ÓÃÄÚ´æ±äµÃȱ·¦Ê±£¬Cache¶ÔÏó×Ô¶¯É¾³ý×îÉÙ±»Ê¹ÓõÄÏî¡£Äã¿ÉÒÔͨ¹ý¶¨Òåʱ¼äÏÞÖÆ¡¢ÒÀÀµÏî¡¢ÒÔ¼°Ïî
ÔÚCache¶ÔÏóÖеÄÓÅÏȼ¶À´Ó°Ïì Cache¶ÔÏó±£ ......

SQL Server ÁÙʱ±íµÄɾ³ý

ÁÙʱ±íÓëÒ»°ãµÄ±í²»Í¬£¬ËüÊDZ£´æµ½tempDb±íÖС£ÁÙʱ±íµÄ±íÃûÓëÄãËù½¨µÄ±íÃûÒ²²»Ò»Ñù£¬ÒòΪËûҪΪ²»Í¬È˵ÄÏàͬ²Ù×÷´´½¨²»Í¬µÄÁÙʱ±í¡£
1¡¢´íÎóµÄɾ³ý²Ù×÷£º
--´íÎóµÄÁÙʱ±íɾ³ý²Ù×÷£¬ÒòΪËùÔÚÊý¾Ý¿â²»Í¬
IF  EXISTS (SELECT * from sysobjects WHERE object_id = OBJE ......

SQL Server´´½¨ÊÓͼ

2009-10-08 16:05
ʲôÊÇÊÓͼ
     ´ó¼Ò¶¼ÖªµÀ£¬ÎÒÃǹú¼ÒÏÖÔÚ“ÉñÆß”ÉÏÌìÁË¡£´ÓÃÀ¹úµÄÔÂÇòµÇÔ¿ªÊ¼£¬ÈËÀàÉÏÌì²»ÔÙÊÇÉñ»°¡£Ìý˵£¬ÔÚÃÀ¹ú£¬ÄãÖ»Òª³ö¼¸Ê®ÍòÃÀÔª£¬Äú¾Í¿ÉÒÔÉÏÒ»´ÎÔÂÇò½øÐÐÌ«¿ÕÂÃÐУ¬ËùÒÔ£¬ÎÒÃÇÏàÐÅ£ºÔÚ²»¾ÃµÄ½«À´£¬ÉÏÌìÂÃÐн«×ß½øÎÒÃǰÙÐÕµÄÉú»î£¬ÄÇÊÇÒ»¼þ¶àôÐÂÏÊÉñÆæµÄÊÂÇé° ......

¹æ»®ÔºÅàѵ·ÑÓÃͳ¼Æ²éѯµÄsqlÓï¾ä

create or replace view pxfy_view as
select t1.form_id,t1.reserve as mid,t1.feiyong,t.cjpxr_name as full_name,1 as pxlx,t1.topic,t1.identity,
     t1.begin_time as CREATEDATE,t1.end_time as completedate,pv.city,pv.DEPT_ID
     from wf_oa_pxnb_cjry t,WF_OA_PX ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ