create proc sp_Test
@year nvarchar(10),
@month nvarchar(10),
@day nvarchar(10),
@today datetime,
@year=cast(year(getdate()) as nvarchar(10)),
@month=cast(month(getdate()) as nvarchar(10)),
@day=cast(day(getdate()) as nvarchar(10)),
@today = @year + '-' + @month + '-' + @day
as
select * from ......(此处是SQL语句)
@year nvarchar(10),
@month nvarchar(10),
@day nvarchar(10),
@today datetime,
@year=cast(year(getdate()) as nvarchar(10)),
@month=cast(month(getdate()) as nvarchar(10)),
@day=cast(day(getdate()) as nvarchar(10)),
@today = @year + '-' + @month + '-' + @day
as
select * from ......(此处是SQL语句)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货