Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

±í1
ÁÐÃû ¿ªÊ¼ ½áÊø
Êý¾Ý 2010-05-25 11:00 2010-05-29 14:00


ÈçºÎ²ÅÄÜת»»³ÉÒÔÏÂÊý¾Ý

±í2
ÁÐÃû ¿ªÊ¼ ½áÊø
Êý¾Ý 2010-05-25 11:00 2010-05-25 18:00
  2010-05-26 09:00 2010-05-26 18:00
  2010-05-27 09:00 2010-05-27 18:00
  2010-05-28 09:00 2010-05-28 18:00
  2010-05-29 09:00 2010-05-29 14:00
¿ªÊ¼ºÍ½áÊø ¶¼ÊÇdatetimeÊý¾ÝÀàÐÍ



ûÍêÈ«¿´Ã÷°×LZµÄ±í½á¹¹ÊÇʲôÇé¿ö¡£
Èç¹ûÊÇÈÕÆÚʱ¼ä¶Î»®·ÖµÄ»°£¬¿ÉÒԲο¼ÏÂÃæ´úÂ룺
SQL code:

DECLARE @BDate datetime
DECLARE @EDate datetime
SET @BDate = '2010-05-25 11:00'
SET @EDate = '2010-05-29 14:00'

SELECT
BTime = CASE WHEN @BDate > BTime THEN @BDate ELSE BTime END,
ETime = CASE WHEN @EDate < ETime THEN @EDate ELSE ETime END
from (
SELECT
BTime = DATEADD(hour, 9,date),
ETime = DATEADD(hour,18,date)
from (
SELECT date = DATEADD(day,n-1,CONVERT(char(8),@BDate,112))
from Nums
WHERE n <= DATEDIFF(day,@BDate,@EDate)+1
) Calendar
) tmp



ÆäÖУº
Nums(n int NOT NULL PRIMARY KEY CLUSTERED)´æ´¢1µ½1MµÄÊý×Ö¡£

Ò²¿ÉÒÔרÃŽ¨Ò»¸öCalendar±í£¬´æ´¢ÆóÒµ¿ÉÄÜÓõ½µÄÈÕÆÚÊý¾Ý£¬Ò»ÌìÒ»Ìõ¼Ç¼£¬ÒÔÈÕÆÚΪÖ÷¼ü£¨ÇÒ¾Û½¹Ë÷Òý£©£¬»¹¿ÉÒÔ±£´æ¹¤×÷ÈÕ¡¢¿ªÅÌÈÕ£¨¹ÉƱÐÐÒµ£©µÈÌØÊâÈÕÆÚ£¬ÒÔ¹


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ