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

declare @tmp table
(
id int identity(1,1),
TableName varchar(100),
Column_name varchar(100),
Type varchar(50),
Lenght int,
Scale int,
Nullable varchar(1),
Defaults varchar(4000),
PrimaryKey varchar(1)
)
select iid = identity(int,1,1), * into #a from SysObjects where xtype = 'U'
declare ......

SQL Server 2005 Express Edition ɵ¹Ïʽ°²×°

      ÓÉÓÚ×î½üÒªÓõ½´ò°üSQL Server 2005 Express Edition £¬ÓÉÓÚÔÚ°²×°¹ý³ÌÖÐÐèÒªÉèÖúܶණÎ÷¡£´øÀ´ºÜ¶àµÄ²»±ã£¬ÓÚÊÇÔÚÍøÉϺÍMSDNÕÒÁ˺þÃÖÕÓÚÕÒµ½°ì·¨ÁË ^_^
ÎÒÓõÄÊÇÅú´¦ÀíÀ´ÊµÏֵģ¬ºÃÁËÖ±½ÓÌù´úÂë
CLS  
@ECHO OFF  
ECHO.     
ECH ......

SQL SERVER ÓÃsqlÓï¾äÈçºÎ»ñµÃµ±Ç°ÏµÍ³Ê±¼ä


SQL SERVER 2000ÓÃsqlÓï¾äÈçºÎ»ñµÃµ±Ç°ÏµÍ³Ê±¼ä
¾ÍÊÇÓÃGETDATE();
SqlÖеÄgetDate()2008Äê01ÔÂ08ÈÕ ÐÇÆÚ¶þ 14:59
Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2008 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/08
Select CONVERT(varchar(100), ......

MS Sql server²é¿´¶ÔÏó·½·¨£¨ÍêÉÆÖУ©

MS Sql server Êý¾Ý¿â
1.°´¶¨Òåʱ´æ´¢×´Ì¬·ÖÐÐÏÔʾ¶¨Ò壨sp_helptext´æ´¢¹ý³Ì£©£¬µ÷ÓãºExec sp_helptext '¶ÔÏóÃû'
2.ÒÔ±í¸ñÐÎʽÏÔʾ·µ»ØÏà¹Ø²ÎÊý(sys.objectsÊÓͼ),µ÷Óãºselect * from sys.objects where name='¶ÔÏóÃû'
3.×÷Ϊ½á¹û¼¯ÏÔʾ¶¨Ò壨object_definition£©£¬µ÷Óãºselect object_definition(object_id('¶ÔÏóÃû ......

Á·Ï°ÐÐÁÐת»» sql server 2000

ÒÀ¾Ýcsdn¸ßÊÖдµÄ×Ô¼ºÁ·Ï°Ò»Ï·½±ãÒÔºó²éÕÒ
--Creator:Gongl
--Date:2009-1-8
--sql server 2000
--ѧϰÐÐתÁУ¬ÎªÁ˽øÒ»²½Á˽⶯̬sqlÆ´½Ó£¨µ¥Ë«ÈýÒýºÅ£©
--¼¸ÖÖÀàÐÍ
--Numeric(10,2) Ö¸×Ö¶ÎÊÇÊý×ÖÐÍ,³¤¶ÈΪ10 СÊýΪÁ½Î»
--varcharºÍnvarcharµÄÇø±ð
--1.´Ó´æ´¢·½Ê½ÉÏ£¬nvarcharÊǰ´×Ö·û´æ´¢µÄ£¬¶ø varcharÊǰ´×Ö½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ