指数据库名称、表名、创建实体表

DECLARE @DBNAME VARCHAR(30)
DECLARE @FGUID VARCHAR(36),@FCLASS VARCHAR(30),@TABLENAME VARCHAR(100)

SET  @DBNAME='test'
SET @FGUID='88740E5BBF8E11EC80CBC46C693'
SET @FCLASS='TMP'
SET @TABLENAME=@DBNAME+'.dbo.'+@FCLASS+@FGUID
-- TODO: 在此处设置参数值。
EXECUTE   [dbo].[PROC_CREATETEMPTABLENAME] @DBNAME,@FGUID,@FCLASS
DECLARE @sql VARCHAR(MAX)
SET @sql='INSERT INTO '+@TABLENAME+' EXECUTE  [PROC_BHR_ExpansionBom] @PFNUMBER=''2101-00005001''
  ,@ISSINGLE=''N'''
SELECT @sql
EXEC (@sql);