34,837
社区成员
发帖
与我相关
我的任务
分享存储过程的参数，默认为 year(getdate())为什么不可以？
create procedure xxx
@year int = (year(getdate()))
as
return @year
为什么不可以
...全文
请发表友善的回复…
发表回复
yyhyy23 2004-12-06
- 打赏
- 举报
create procedure xxx
@year int
as
begin
select @year=(year(getdate()))
return @year
end
go
@year int
as
begin
select @year=(year(getdate()))
return @year
end
go
yyhyy23 2004-12-06
- 打赏
- 举报
要做一次转换
WYC2300 2004-12-06
- 打赏
- 举报
create procedure xxx
@year int=null
as
begin
select @year=(year(getdate()))
return @year
end
@year int=null
as
begin
select @year=(year(getdate()))
return @year
end
yyhyy23 2004-12-06
- 打赏
- 举报
create procedure xxx
@year int = cast((year(getdate())) as int)
as
return @year
@year int = cast((year(getdate())) as int)
as
return @year
zj181314 2004-12-06
- 打赏
- 举报
？？
jackluo1981 2004-12-06
- 打赏
- 举报
create procedure xxx
as
begin
select @year=(year(getdate()))
return @year
end
as
begin
select @year=(year(getdate()))
return @year
end
jackluo1981 2004-12-06
- 打赏
- 举报
crate procedure xxx
as
begin
select @year=(year(getdate()))
return @year
end
as
begin
select @year=(year(getdate()))
return @year
end
zj181314 2004-12-06
- 打赏
- 举报
也就是我想 得到当前年份为默认参数。
zj181314 2004-12-06
- 打赏
- 举报
算了
create procedure xxx
@year int = null
as
if @year is null
begin
@year = year(getdate())
end
。。。
只好这样做了。
还是要感谢各位，给分啦！！ *^_^*
zj181314 2004-12-06
- 打赏
- 举报
哎~~~ 难道真的不行吗？
comszsoft 2004-12-06
- 打赏
- 举报
getdate()是动态改变的，不能用来做形参
zclxyh 2004-12-06
- 打赏
- 举报
create procedure xxx
@year int out
as
begin
select @year=(year(getdate()))
return @year
end
go
@year int out
as
begin
select @year=(year(getdate()))
return @year
end
go
