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

ÈçºÎ¼ÆËãMS SQLÓï¾äÖ´ÐеÄʱ¼ä»¹ÓÐc#


MSSQL:
declare @begin datetime
declare @End datetime
set @begin=getdate()
   --Ö´ÐеÄÓï¾äдÔÚÕâÀï
set @End=getdate()
select datediff(millisecond,@begin,@End) as Ö´ÐеÄʱ¼ä
--millisecond±íʾºÁÃë Èç¹û¿´Ãë¿ÉÒÔʹÓÃss
C#:
ºÜ¶àʱºò£¬ÎÒÃǶÔ×Ô¼ºµÄ³ÌÐòµÄÆ¿¾±²»ÊǺÜÇå³þ¡£ÈçÒ»¸ö±¾µØÀàºÍÒ»¸öwebserviceÖ®¼äµÄµ÷Óõ½µ×ÊÇÓжà´óµÄÇø±ð¡£Ò³ÃæÕû¸öµÄÖ´ÐÐʱ¼äÔõôÑù¼à¿Ø¡£³ÌÐòÊÇÔÚÄǸöµØ·½»¯µÄʱ¼ä×¡£ÏÖÔÚÎҾͰÑ.NET2.0ÒÔºóµÄ¼à¿Ø·½·¨ËµÏ¡£ÆäʵºÜ¼òµ¥£¬Ö»ÒªÔÚSystem.Diagnostics ÖоÍÓÐÒ»¸ö¿ÉÒÔÖ±½ÓʹÓõÄÀà --Stopwatch¡£²»¶à˵ÁË¡£½«´úÂëÌù³öÀ´¡£
 protected void Page_Load(object sender, EventArgs e)
    {
        Stopwatch watch = new Stopwatch(); //ʵÀý»¯Ò»¸ö¼à¿Ø¶ÔÏó
        watch.Start();  //¿ªÊ¼¼à¿ØÒµÎñÂß¼­
        
        string a = null;
        for (int i = 0; i < 10000; i++)
        {
          a = i.ToString();
        }
        Thread.Sleep(10); //½«Ïß³ÌÑÓ³Ù10ºÁÃë¡£Ò»¸ö¶àÕâÑùµÄ²âÊÔ£¬¶àҪʹÓõ½Ï̷߳½Ãæ
        watch.Stop(); //½áÊø¼à¿Ø
        Response.Write(watch.ElapsedMilliseconds); //Êä³ö¼ÆÊ±½á¹û£¬µ¥Î»£ººÁÃë
    }


Ïà¹ØÎĵµ£º

PL/SQL±¨ÎÞЧµÄ´°¿Ú¾ä±úµÄ½â¾ö°ì·¨

ÎÒÔÚʹÓÃPL/SQLʱ£¬µã»÷ij¸ö×Ö¶ÎÅԱߵÄС°´Å¥Ï£Íûµ¯³ö±à¼­´°¿Úʱ£¬PL/SQLÌáʾ“ÎÞЧµÄ´°¿Ú¾ä±ú”¡£Ò»Ö±²»Ã÷°×ÊÇÔõô»ØÊ£¬ºóÀ´baiduÁËÏ£¬²ÅÖªµÀÕâ¸ö¹¦ÄܺÍwindowsµÄprint spooler·þÎñÓйء£Æô¶¯¸Ã·þÎñ¾Í¿ÉÒÔÁË¡£ ......

C#ÖжÔXML½Úµã½øÐÐÔöɾ¸Ä²é

ºÅ³ÆxmlhelperµÄÒ»¸öÀà
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Xml;
namespace WebApplication2
{
/// <summary>
/// XMLHelper XMLÎĵµ²Ù×÷¹ÜÀíÆ÷
/// </summary>
public class XMLHelper
{
public X ......

sqlµÄjoin

¶ÔÓÚÎÒÃÇÕâЩ½öÓõ½sql¼òµ¥²éѯ¿ª·¢ÈËÔ±À´Ëµ£¬¿ÉÄÜÖ»Á˽âһЩ»ù±¾µÄsqlº¯ÊýºÍ<>=ÕâÑùµÄÌõ¼þÓï¾ä£¬½ñÌìÒ»¸öÅóÓÑÎÊÆð£ºÄ¬ÈϵÄjoinÊÇouter»¹ÊÇinner¡£¡£¡£¡£
ÌØµØÊÕ¼¯ÁËһЩ¶«Î÷£¬Ò²Ìù³öÀ´ºÍ´ó¼Ò·ÖÏíÏ£º
joinleft outer join=left join ,   right outer join=right join,     inner jo ......

SQL server 2005ÖÐÎÞ·¨Ð½¨×÷Òµ£¨Job£©µÄÎÊÌâ

ÔÚʹÓÃsqlserver2005´´½¨×÷ҵʱ£¬´´½¨²»ÁË£¬Ìáʾ
ÎÞ·¨½«ÀàÐÍΪ“Microsoft.SqlServer.Management.Smo.SimpleObjectKey”µÄ¶ÔÏóÇ¿ÖÆ×ª»»ÎªÀàÐÍ“Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey”¡£   (Microsoft.SqlServer.Smo)
ÓÚÊǾÍgoogle£¬°Ù¶ÈÁËһϣ¬ºÃ¶àÎÄÕºÍÌù×Ó˵ÐèÒª° ......

SQL SERVERÊÂÎñ¸´ÖÆ£­£­¹¤×÷Ô­Àí²âÊÔ

ÈÕÖ¾¶ÁÈ¡Æ÷Ö»½«ÒѾ­COMMITµÄÊÂÎñ´«Ë͵½·Ö·¢Êý¾Ý¿â¡£
²âÊÔ·½·¨£º
1. ÔÚ·¢²¼Êý¾Ý¿âÖ´ÐУº
begin tran
insert  testTable2 (aaa,bbb,ddd,ccc)
values ('jawefwao','jfowijef','jaiwejfo','civjoiw')
insert  testTable2 (aaa,bbb,ddd,ccc)
values ('jawefwao2','jfowijef2','jaiwejfo2','civjoiw2')
insert& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ