VanillaGranilla

testTableCreator.sql

Feb 4th, 2015
438
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.77 KB | None | 0 0
  1.  
  2. USE myDatabase;
  3. GO
  4.  
  5. DROP TABLE dbo.aaaJim
  6.  
  7. CREATE TABLE dbo.[aaaJim]
  8. (  
  9.  [Id] [INT] IDENTITY(1,1) NOT NULL,
  10.  [ProductName] [NCHAR](50) NULL,
  11.  [ProductDescription] [NCHAR](3000) NULL,
  12.  [Dateadded] [datetime] NOT NULL,
  13. CONSTRAINT [PK_Jim_1] PRIMARY KEY CLUSTERED
  14. (
  15.     [Id] ASC
  16. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
  17. ON [PRIMARY])
  18.  
  19.  
  20.  
  21.  
  22. BEGIN TRAN
  23.  
  24.  
  25.   BEGIN
  26.  
  27.   DECLARE @Record INT
  28.   SET @Record=1
  29.   WHILE @Record<=1000
  30.   BEGIN
  31.     INSERT INTO vca.dbo.aaaJim
  32.     ([ProductName] ,[ProductDescription],[Dateadded])
  33.     VALUES ('Product ' + STR(@Record), 'Description ' + STR(@Record), GETDATE() - @Record)
  34.     SET @RECORD = @RECORD+1
  35.   END
  36.  
  37. END
  38.  
  39. COMMIT TRAN
  40. GO
  41.  
  42. GO
Advertisement
Add Comment
Please, Sign In to add comment