我想將一個日期傳遞給我的存盤程序,這可以是任何日期:
2022-04-18
如果可能排除周末,我將如何回傳一周中接下來的 4 天,但這不是必需的。
預期輸出:
2022-04-18
2022-04-19
2022-04-20
2022-04-21
2022-04-22
uj5u.com熱心網友回復:
CREATE procedure spDateMessing(@d as date)
as
with cte as
(
select n from (values(0),(1),(2),(3),(4)) as t(n)
)
select n,cast(DATEADD(D,n,@d) as date) as Date_ from cte
轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/461157.html
