从文本中得到060317 string型日期在插入varchar型字段后,在sp中按时间类型取出然后加两天日期,再按照varchar型输出,并且格式要变成20060317,求一个简单语句,MS SQL中字符型,数据型,和日期型转化很部灵活.我在存储过程中目前写的是这样,请高手优化一下:
declare @intTest int,
@varcharTest varchar(8)
set @intTest = cast('051221' as int) +2
print @intTest
set @varcharTest = right('00200'+cast(@intTest as varchar(8)),8)
print @varcharTest
declare @intTest int,
@varcharTest varchar(8)
set @intTest = cast('051221' as int) +2
print @intTest
set @varcharTest = right('00200'+cast(@intTest as varchar(8)),8)
print @varcharTest
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货