如何参数化简单的创建表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/