PARSE関数
--数値型 declare @n varchar(1000) = '123,456' print parse(@n as decimal) --日付型 declare @d varchar(10) = '2016/11/05' print parse(@d as datetime) print dateadd(month,2,parse(@d as datetime))
<出力結果>
123456
11 5 2016 12:00AM
01 5 2017 12:00AM