create proc alterzcmx
@dml nvarchar(128)
as
declare @sqlstr nvarchar(2000)
set @sqlstr='update '+@dml+' set monthzjl=((1/yjsynx)/12)'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set monthzje=monthzjl*yz'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set yearzje=monthzje*12'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set ljzj=yymonth*monthzje'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set jz=yz-ljzj '
exec sp_executesql @sqlstr
@dml nvarchar(128)
as
declare @sqlstr nvarchar(2000)
set @sqlstr='update '+@dml+' set monthzjl=((1/yjsynx)/12)'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set monthzje=monthzjl*yz'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set yearzje=monthzje*12'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set ljzj=yymonth*monthzje'
exec sp_executesql @sqlstr
set @sqlstr='update '+@dml+' set jz=yz-ljzj '
exec sp_executesql @sqlstr