alter table test add test nvarchar(50) --展示你要的结果
--test是我新建的表名alter table test add id int identity(1,1)--中间过程要用到,可以删除declare @count int declare @id intdeclare @year nvarchar(4)declare @month nvarchar(2)declare @day nvarchar(2)declare @hour nvarchar(2)declare @min nvarchar(2)set @id=1select @count=count(*
select *,cast(a01 as varchar)+'-'+right('00'+cast(a02 as varchar),2)+'-'+right('00'+cast(a03 as varchar),2)+' '+right('00'+cast(a04 as varchar),2)+':'+right('00'+cast(a05 as va