Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE myDatabase;
- GO
- DROP TABLE dbo.aaaJim
- CREATE TABLE dbo.[aaaJim]
- (
- [Id] [INT] IDENTITY(1,1) NOT NULL,
- [ProductName] [NCHAR](50) NULL,
- [ProductDescription] [NCHAR](3000) NULL,
- [Dateadded] [datetime] NOT NULL,
- CONSTRAINT [PK_Jim_1] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
- ON [PRIMARY])
- BEGIN TRAN
- BEGIN
- DECLARE @Record INT
- SET @Record=1
- WHILE @Record<=1000
- BEGIN
- INSERT INTO vca.dbo.aaaJim
- ([ProductName] ,[ProductDescription],[Dateadded])
- VALUES ('Product ' + STR(@Record), 'Description ' + STR(@Record), GETDATE() - @Record)
- SET @RECORD = @RECORD+1
- END
- END
- COMMIT TRAN
- GO
- GO
Advertisement
Add Comment
Please, Sign In to add comment