±È½ÏÁ½ÌõSQLÓï¾äÔËÐÐʱ¼ä
create proc dbo.PROC_SQL_COMP @sql1 varchar(8000),@sql2 varchar(8000),@t int
as
/*
µ÷Óãºexec dbo.PROC_SQL_COMP @sql1='',@sql2='',@t=5
×¢£ºÒÔÏÂʱ¼äµ¥Î»Îªms(millisecond ºÁÃë)
±È½ÏÁ½Ìõ¼þSqlÓï¾äÖ´ÐÐʱ¼ä,@sql1¡¢@sql2ΪҪ±È½ÏµÄsqlÓï¾ä,@tΪsqlÒªÔËÐеĴÎÊý£¬½á¹ûΪƽ¾ùÖµ
·µ»Ø: AVG1 @sql1ËùÓÃÆ½¾ùʱ¼ä
AVG2 @sql2ËùÓÃÆ½¾ùʱ¼ä
DT1 @sql1ËùÓÃ×Üʱ¼ä
DT2 @sql2ËùÓÃ×Üʱ¼ä
TIMES Ö´ÐдÎÊý
*/
declare @dt1 datetime,
@dt2 datetime,
@dt3 datetime,
@dt4 datetime,
@ms1 bigint,
@ms2 bigint,
@i int
set @ms1 = 0
set @ms2 = 0
set @i = 0
--¿ªÊ¼²âÊÔ
while @
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://news.newhua.com/news1/program_database/2008/530/0853093226E2KJ93C02415FEB1CD9A5HCKA821556279EEKJ7728GI5.html
ÊÂÎñÈÕÖ¾ÎļþTransaction Log FileÊÇÓÃÀ´¼Ç¼Êý¾Ý¿â¸üÐÂÇé¿öµÄÎļþ£¬À©Õ¹ÃûΪldf¡£
ÔÚ SQL Server 7.0 ºÍ SQL Server 2000 ÖУ¬Èç¹ûÉèÖÃÁË×Ô¶¯Ôö³¤¹¦ÄÜ£¬ÊÂÎñÈÕÖ¾Îļþ½«»á×Ô¶¯À©Õ¹¡£
Ò»° ......
1¡¢SQLÊÇÒ»ÖÖ˵Ã÷ÐÔÓïÑÔ£¬²»Êǹý³Ì»¯ÓïÑÔ¡£ÀàËÆ“¼ìË÷->¼ì²é->²åÈë->¸üДµÄ¹ý³Ì»¯²½ÖèµÄ˳ÐòÊÇûÓÐÒâÒåµÄ¡£Ó¦¸ÃÒÔÐм¯µÄ·½Ê½Ë¼¿¼£¬ÒÔÃèÊöÒ»¸öÂß¼µÄÓïÑÔ·½Ê½Ë¼¿¼¡£
2¡¢ÔÚÉè¼ÆÊý¾Ý¿â±í×Ö¶Îʱ£¬Ò»¸öÐÐÃèÊöÓ¦¸Ã°üº¬Ò»¸öÊÂʵ£¬¶øÇÒÊÇÈ«²¿ÊÂʵ¡£ÀýÈ翼ÇÚ¿¨µÄÉè¼Æ£¬
²»ÒªÉè¼ÆÎª£º[ userId, puchTime, even ......
--> Title : ijÍâÆóSQL ServerÃæ試題
--> Author : wufeng4552
--> Date : 2010-1-15
Question 1£ºCan you use a batch SQL or store procedure to calculating the Number of Days in a Month
Answer 1£ºÕÒ³öµ±ÔµÄÌìÊý
select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast( ......
MFCÖÐÓÃado·ÃÎÊSQL Server 2005Êý¾Ý¿â
½ñÌìÀÏ´ó½»´úÏîÄ¿£¬ÐèÒªMFC·ÃÎÊÁíһ̨»úÆ÷É쵀 SQL Server 2005Êý¾Ý¿â¡£MFCÎÒ²»Ê죬SQLÒ²´ÓûÓùý¡£ÔÚÍøÉϲéÁ˲»ÉÙ×ÊÁÏ£¬Ã¦ÁËÒ»ÕóÖÕÓÚ¸ãͨÁË¡£Óë¸÷λÅóÓÑ·ÖÏíһϣ¬¸ßÊÖÃǾͲ»Óÿ´ÁË£¬ÕâÊÇд¸øÏñÎÒÒ»Ñù³õѧÕߵġ£
Ò»¡¢°²×°SQL SERVER 2005£¬ÔÚ±¾»ú½¨Á¢·þÎñÆ÷ĬÈϰ²×°¼´¿É£¬Ò²¿ÉÒÔ×Ô¼ ......
Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......