Çó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±í£¬´æ´¢ÆóÒµ¿ÉÄÜÓõ½µÄÈÕÆÚÊý¾Ý£¬Ò»ÌìÒ»Ìõ¼Ç¼£¬ÒÔÈÕÆÚΪÖ÷¼ü£¨ÇÒ¾Û½¹Ë÷Òý£©£¬»¹¿ÉÒÔ±£´æ¹¤×÷ÈÕ¡¢¿ªÅÌÈÕ£¨¹ÉƱÐÐÒµ£©µÈÌØÊâÈÕÆÚ£¬ÒÔ¹
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
ÐèÇóÈçÏ£º
ѧԺ 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
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......