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

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

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

ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ

Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracle ÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR Oracle ÀïÃæ×î´ó³¤¶ÈΪ 4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHAR ǰÕß×î´ó³¤¶È2kb ......

¾«ÃîSqlÓï¾ä

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database ......

Á·Ï°ÐÐÁÐת»» 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ºÅ