ms sql根据表明变量动态创建表

有些时候需要根据变量批量创建表，下面是个ms sql根据表明变量动态创建表 存储过程实例，在MSSQL2008下调试通过。

USE [UNICOM_MAIL_ACCOUNT]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:

-- Create date:

-- Description:

-- =============================================

ALTER PROCEDURE [dbo].[csp_create_unicom_mailbox_tb]

-- Add the parameters for the stored procedure here

@tbname varchar(50)

AS

BEGIN

  Declare @Sql As varchar(8000)

    Set @Sql = 'Create Table '+ @tbname +'(

[FName] [varchar](50) NULL,

[LName] [varchar](50) NULL,

[Name] [varchar](50) NULL,

[Sex] [varchar](50) NULL,

[Company] [varchar](50) NULL,

[Department] [varchar](50) NULL,

[MPhone] [varchar](50) NULL,

[Email] [varchar](50) NULL,

[SEmail] [varchar](50) NULL,

[Account] [varchar](50) NULL,

[PhoneAlipay] [int] NULL,

[EmailAlipay] [int] NULL

) ON [PRIMARY]'

  execute(@Sql)

END