如何在存储过程里创建视?

Question

CREATE PROCEDURE test  
AS
exec ('CREATE VIEW [dbo].[XpressII_Fusion]
AS
SELECT dbo.XpressII.Order_Section, dbo.XpressII.Fscl_Month, 
      dbo.XpressII.Product_Number, dbo.XpressII.Shpt_Leg_Net_CLC, 
      dbo.XpressII.Shpt_Leg_Prod_Units, dbo.XpressII.Misc_Charge_Code, 
      dbo.XpressII.Customer_PO_Number, dbo.XpressII.Customer_Number, 
      dbo.XpressII.Purch_Agreement, dbo.XpressII.Order_Date, 
      dbo.FUSION_SHPT.Accountid#, dbo.FUSION_SHPT.[Last-Tier#], 
      dbo.XpressII.EM
FROM dbo.FUSION_SHPT INNER JOIN
      dbo.XpressII ON dbo.FUSION_SHPT.[ORDER-SEC] = dbo.XpressII.Order_Section')GO