±È½ÏÁ½Ìõ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 @
Ïà¹ØÎĵµ£º
¶ÔͬһÕÅ±í½øÐÐÁ½ÖÖ·½Ê½²éѯ£¨½á¹û¼¯Ïàͬ£©£º
case1 ²éѯÌõ¼þ:°üÀ¨¼ÆËã»úÃû£¬êdzƣ¬Ìí¼Óʱ¼äµÈµÈһЩÏÞÖÆÌõ¼þ×ֶΡ£¶øÇÒÐèÁª±í²éѯ±ðµÄ±í
²éѯÊý¾ÝÁ¿£º 100Íò 200Íò
µ¥´¿Ö´ÐÐSQLÓï¾äËùÐèʱ¼ä£º31ºÁÃë&nbs ......
À´×Ôhttp://hi.baidu.com/zcy60156/blog/item/42b6c5802a33859af603a685.html
ÍÆ¼öÊÇÓô洢¹ý³Ì¼ÓÊÂÎñʵÏÖ.»òÖ±½ÓÔÚaspÀïд¼ÓÉÏÊÂÎñ¾Í¿ÉÒÔͬʱµÄ²åÈëÁË.Èç¹ûÖмä³ö´íµÄ»°»¹Äܻعö,¿É±£³ÖÊý¾ÝµÄÒ»ÖÂÐÔ.È¥baiduÉÏËÑË÷Ò»ÏÂÊÂÎñµÈµÄÏà¹Ø×ÊÁϺܶàµÄ.
ÔÚ¿ª·¢WebÓ¦ÓÃʱ£¬ÎÞÒ»ÀýÍâµØÐèÒª·ÃÎÊÊý¾Ý¿â£¬ÒÔÍê³É¶ÔÊý¾ÝµÄ²éѯ¡¢²åÈë¡¢¸ ......
ת×Ô£ºhttp://news.newhua.com/news1/program_database/2008/530/0853093226E2KJ93C02415FEB1CD9A5HCKA821556279EEKJ7728GI5.html
ÊÂÎñÈÕÖ¾ÎļþTransaction Log FileÊÇÓÃÀ´¼Ç¼Êý¾Ý¿â¸üÐÂÇé¿öµÄÎļþ£¬À©Õ¹ÃûΪldf¡£
ÔÚ SQL Server 7.0 ºÍ SQL Server 2000 ÖУ¬Èç¹ûÉèÖÃÁË×Ô¶¯Ôö³¤¹¦ÄÜ£¬ÊÂÎñÈÕÖ¾Îļþ½«»á×Ô¶¯À©Õ¹¡£
Ò»° ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
--> 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( ......