Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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); //Êä³ö¼ÆÊ±½á¹û£¬µ¥Î»£ººÁÃë
    }


Ïà¹ØÎĵµ£º

sqlÖ®truncate ¡¢deleteÓëdropÇø±ð

truncate ¡¢deleteÓëdropÇø±ð
Ïàͬµã£º
truncate ºÍ²»´ø where ×Ó¾äµÄ delete£¬ÒÔ¼° drop ¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã£º
1. truncate ºÍ delete ֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
drop Óï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain)¡¢´¥·¢Æ÷(trigger)¡¢Ë÷Òý(index)£»ÒÀÀµÓڸñíµÄ´æ´¢¹ý³Ì/º¯Êý½«±£Áô,µ«ÊDZäΪ invalid ×´Ì ......

sql server 2008 ´´½¨Óû§

 
ÕâÁ½ÌìÓõ½ÁË sql server 2008 £¬Ö÷ÒªÊǽ¨Êý¾Ý¿â£¬½¨±íºÍ´´½¨Óû§¡£
 
ÔÚ “Windows Éí·ÝÑéÖ¤”   Ï£¬´´½¨ÁËÊý¾Ý¿âºÍ Óû§£¬È»ºóÓà SQL Server Éí·ÝÑéÖ¤  µÇ¼ £¬È´Ìáʾ ´íÎó 18452£¬
ÕÒÁËÒ»ÏÂ×ÊÁÏ ¸Ä·¨ ÈçÏ£º
[ÎÞ·¨Á¬½Óµ½·þÎñÆ÷ ·þÎñÆ÷£ºÏûÏ¢18452£¬ ¼¶±ð16£¬×´Ì¬1 [Microsof ......

¾­µäSQLÓï¾ä´óÈ«

¾­µäSQLÓï¾ä´óÈ«
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ ......

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 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ºÅ