如何参数化简单的创建表SQL查询?

CREATE TABLE `rmr_form` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(80) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
)


请帮助和解释。我真的很感激。 :(
谢谢你们!

最佳答案

您可以使用proc来做到这一点。

CREATE PROCEDURE [dbo].[sp_tabCreate]
        @tabName        nvarchar(30)
        AS
        BEGIN

        IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(@tabName) AND type in (N'U'))
DROP TABLE [dbo].[@tabName]

DECLARE @SQLString NVARCHAR(MAX)
    Set @SQLString = 'CREATE TABLE ' +@tabName+
    '(
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [RankID] [int] NOT NULL,
    [SlotTime] [nvarchar](10) NOT NULL,
    [SlotDate] [nvarchar](30) NOT NULL
) ON [PRIMARY]'

EXEC (@SQLString)
END


并将字段切换为“ @tabName”之类的参数

关于jquery - 如何参数化SQL查询,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/23065536/

10-12 02:40
查看更多