存储过程的参数,默认为 year(getdate())为什么不可以? crate procedure xxxas beginselect @year=(year(getdate()))return @yearend 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create procedure xxxas beginselect @year=(year(getdate()))return @yearend create procedure xxx@year int = cast((year(getdate())) as int) as return @year create procedure xxx@year int=nullas beginselect @year=(year(getdate()))return @yearend create procedure xxx@year intas beginselect @year=(year(getdate()))return @yearendgo create procedure xxx@year int outas beginselect @year=(year(getdate()))return @yearendgo getdate()是动态改变的,不能用来做形参 算了create procedure xxx@year int = nullas if @year is null begin @year = year(getdate()) end只好这样做了。还是要感谢各位,给分啦!! *^_^* SQL2005中如何合并表 一条面试的SQl没写出来,面试黄了 求一这样一条SQL语句,困扰我好几天了!! select中判断输出? 谁能告诉我这条语句有什么问题? --------帮老鼠MM问个问题---------- select *,逗号是什么意思? 存储过程一个棘手问题 多表查询 - 急!!! 我要风了!!哪 里有FOXPRO 2。5B下载呀???? 查询语句性能比较? 如何得到一个服务器上的所有的有用户创建的数据库名字??
as
begin
select @year=(year(getdate()))
return @year
end
@year int = cast((year(getdate())) as int)
as
return @year
@year int=null
as
begin
select @year=(year(getdate()))
return @year
end
@year int
as
begin
select @year=(year(getdate()))
return @year
end
go
@year int out
as
begin
select @year=(year(getdate()))
return @year
end
go
算了create procedure xxx
@year int = null
as
if @year is null
begin
@year = year(getdate())
end
只好这样做了。还是要感谢各位,给分啦!! *^_^*