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
Comments