if isnull(@year,0)=0
select @currently_year=''
if @year=2
select @currently_year=substring(convert(char(4),getdate(),111),3,2)
if @year=4
select @currently_year=substring(convert(char(4),getdate(),111),1,4)
if isnull(@month,0)=0
select @currently_month=''以下这句想获取月份:请高手帮助改一下。
if @month=2
select @currently_month=substring(convert(char(4),getdate(),111),3,2)
select @currently_year=''
if @year=2
select @currently_year=substring(convert(char(4),getdate(),111),3,2)
if @year=4
select @currently_year=substring(convert(char(4),getdate(),111),1,4)
if isnull(@month,0)=0
select @currently_month=''以下这句想获取月份:请高手帮助改一下。
if @month=2
select @currently_month=substring(convert(char(4),getdate(),111),3,2)
select @currently_month=datename(month,getdate())
select @currently_month=substring(convert(char(10),getdate(),111),6,2)