[SQL Server]“偷懒”也能更新数据表

use fff
go
create function data_insert1()
RETURNS int
Begin
  Declare @qq int(4)
  declare @table_index int(4),@tj int(4),@yj int(4),@ej int(4),@sj int(4),@sij bigint(8)
  declare @wj bigint(8),@lj bigint(8),@zs bigint(8),@zjl char(15),@table_name char(15)
  declare youbiao cursor for select * from jj for read only
  open youbiao
  fetch next from youbiao into @table_index,@qq,@tj,@yj,@ej,@sj,@sij,@wj,@lj,@zs,@zjl
  while @@fetch_status=0  /*loop rows in the cursor*/
  begin
    declare youbiao_temp cursor for
    select 数据表名 from table_index where 序号=@table_index
    open youbiao_temp
    fetch next from youbiao_temp into @table_name 
    insert @table_name(qq,tj,yj,ej,sj,sij,wj,lj,zs,zjl)
    values(@qihao,@tj,@yj,@ej,@sj,@sij,@wj,@lj,@zs,@zjl)
    deallocate youbiao_temp
  end
  deallocate youbiao
  RETURN @table_index
end
go