declare @ta2 datetime
set @ta2='20071031'
select rtrim (cast (dateadd(day,1,@ta2) as varchar(10)))
我想讓這句話執行後的結果顯示我20071101,請問我要怎麼寫?
set @ta2='20071031'
select rtrim (cast (dateadd(day,1,@ta2) as varchar(10)))
我想讓這句話執行後的結果顯示我20071101,請問我要怎麼寫?
set @ta2= '20071031 '
select convert(varchar(10),dateadd(day,1,@ta2),112)