Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. CREATE TABLE `rmr_form` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `first_name` varchar(80) NOT NULL,
  4. `last_name` varchar(50) NOT NULL,
  5. `email` varchar(50) NOT NULL,
  6. `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  7. `ip` varchar(20) NOT NULL,
  8. PRIMARY KEY (`id`)
  9. )
  10.  
  11. CREATE PROCEDURE [dbo].[sp_tabCreate]
  12. @tabName nvarchar(30)
  13. AS
  14. BEGIN
  15.  
  16. IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(@tabName) AND type in (N'U'))
  17. DROP TABLE [dbo].[@tabName]
  18.  
  19. DECLARE @SQLString NVARCHAR(MAX)
  20. Set @SQLString = 'CREATE TABLE ' +@tabName+
  21. '(
  22. [ID] [int] IDENTITY(1,1) NOT NULL,
  23. [RankID] [int] NOT NULL,
  24. [SlotTime] [nvarchar](10) NOT NULL,
  25. [SlotDate] [nvarchar](30) NOT NULL
  26. ) ON [PRIMARY]'
  27.  
  28. EXEC (@SQLString)
  29. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement