CREATE function dbo.test (@ysrq varchar(10) )
returns varchar(10) as
begin
If Isnull(@ysrq,0)<=0
set @ysrq='2003-09-01'
else
set @ysrq=@ysrq
return @ysrq
end
调用
insert into gxs_lgbjbda(gbbm,csrq)
values(2222,cast(dbo.test('2003-09-09') as datetime))
打开数据库,在数据库的"用户定义的函数"栏中创建
如:
CREATE FUNCTION dbo.GetPositive
(@Value Float)
RETURNS Float AS
BEGIN
If Isnull(@Value,0)<=0 set @Value=0
Return(@Value)
END