存储过程赋值的问题??
create proc sp_Test
@year nvarchar(10),
@month nvarchar(10),
@day nvarchar(10),
@today datetime,
@year=year(getdate()),
@month=month(getdate()),
@day=day(getdate()),
@today = @year + '-' + @month + '-' + @day
as
select * from ......(此处是SQL语句)
问题是在赋值的时候提示错误,@year=year(getdate()),应该如何给@year等变量赋值???