MSSQL让某一字段自增的存储过程

--字段自增存储过程
create PROCEDURE getRecord
  @tblName varchar(255),--表名
  @tbpafldName varchar(255),--主键字段名
  @fldName varchar(255),--自增字段名
  @id int  --主键ID值
   
as 
  declare @updateSQL nvarchar(4000)
  declare @selectSQL nvarchar(4000)
  declare @value int 
 
begin 
     set @selectSQL=N' select @value = '+@fldName+'  from '+@tblName+' where '+@tbpafldName+' = '+convert(varchar,@id)
     exec sp_executesql @selectSQL,  
              	     N'@value int output',  
                     @value output  
  		     select @value   
    set @updateSQL='update '+@tblName+' set '+@fldName+' = '+convert(varchar,@value+1)+' where '+@tbpafldName+' = '+convert(varchar,@id)
end 

exec (@updateSQL)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO