CREATE PROCEDURE te 
@sn varchar(2), 
@zwpj text, 
@fzfx text 
as 
begin
    declare @strSQL   nvarchar(max)       -- 主语句 
    declare @tb  varchar(2) 
    declare @tblName  varchar(10) 

    set @tb='ta' 
    set @tblName = @tb+@sn 


    set @strSQL = 'insert ['+@tblName+'](a,b) 
       values(
    '''+@zwpj+''', 
    '''+@fzfx+''' 
    )' 
    exec (@strSQL) 
end
GO