ÈçºÎ¼ÆËã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); //Êä³ö¼ÆÊ±½á¹û£¬µ¥Î»£ººÁÃë
}
Ïà¹ØÎĵµ£º
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 £¬ÓÉÓÚÔÚ°²×°¹ý³ÌÖÐÐèÒªÉèÖúܶණÎ÷¡£´øÀ´ºÜ¶àµÄ²»±ã£¬ÓÚÊÇÔÚÍøÉϺÍMSDNÕÒÁ˺þÃÖÕÓÚÕÒµ½°ì·¨ÁË ^_^
ÎÒÓõÄÊÇÅú´¦ÀíÀ´ÊµÏֵģ¬ºÃÁËÖ±½ÓÌù´úÂë
CLS
@ECHO OFF
ECHO.
ECH ......
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 Êý¾Ý¿â
1.°´¶¨Òåʱ´æ´¢×´Ì¬·ÖÐÐÏÔʾ¶¨Ò壨sp_helptext´æ´¢¹ý³Ì£©£¬µ÷ÓãºExec sp_helptext '¶ÔÏóÃû'
2.ÒÔ±í¸ñÐÎʽÏÔʾ·µ»ØÏà¹Ø²ÎÊý(sys.objectsÊÓͼ),µ÷Óãºselect * from sys.objects where name='¶ÔÏóÃû'
3.×÷Ϊ½á¹û¼¯ÏÔʾ¶¨Ò壨object_definition£©£¬µ÷Óãºselect object_definition(object_id('¶ÔÏóÃû ......
ÒÀ¾Ýcsdn¸ßÊÖдµÄ×Ô¼ºÁ·Ï°Ò»Ï·½±ãÒÔºó²éÕÒ
--Creator:Gongl
--Date:2009-1-8
--sql server 2000
--ѧϰÐÐתÁУ¬ÎªÁ˽øÒ»²½Á˽⶯̬sqlÆ´½Ó£¨µ¥Ë«ÈýÒýºÅ£©
--¼¸ÖÖÀàÐÍ
--Numeric(10,2) Ö¸×Ö¶ÎÊÇÊý×ÖÐÍ,³¤¶ÈΪ10 СÊýΪÁ½Î»
--varcharºÍnvarcharµÄÇø±ð
--1.´Ó´æ´¢·½Ê½ÉÏ£¬nvarcharÊǰ´×Ö·û´æ´¢µÄ£¬¶ø varcharÊǰ´×Ö½ ......