SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[new_pr_create_pressure_table]
@table nvarchar(64)
AS
BEGIN
EXEC(
'CREATE TABLE [dbo].' + @table + '([Num] [bigint] NOT NULL) ON [PRIMARY]')
END
直接利用参数常见会失败,采用EXEC执行对应的字符串即可。