Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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`)
- )
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement