create function fc_tr(@null char(1)) returns numeric(20) as begin declare @a numeric(20) declare @b numeric(20) set @a = (select rownums from TEMP_ROWNUM) update temp_rownum set rownums = @a+1 set @b = (select rownums from TEMP_ROWNUM) declare @aa numeric(20) set @aa = (select rownums from temp_rownum) return @aa end go
returns numeric(20)
as
begin
declare @a numeric(20)
declare @b numeric(20)
set @a = (select rownums from TEMP_ROWNUM)
update temp_rownum
set rownums = @a+1
set @b = (select rownums from TEMP_ROWNUM)
declare @aa numeric(20)
set @aa = (select rownums from temp_rownum)
return @aa
end
go
在函数内不正确地使用了 'UPDATE'。我试过不行的啊
从而不能正常的update了