打开数据库,在数据库的"用户定义的函数"栏中创建 如: CREATE FUNCTION dbo.GetPositive (@Value Float) RETURNS Float AS BEGIN If Isnull(@Value,0)<=0 set @Value=0 Return(@Value) END
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
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))包错
请问应该怎样改??