Question: Use IF and WHILE to insert 100,000 records into the following table. Place your Database script here that generates the following result. CREATE TABLE [dbo].

Use IF and WHILE to insert 100,000 records into the following table. Place your Database script here that generates the following result. CREATE TABLE [dbo]. [cs110] [ID] int NOT NULL IDENTITY (1, 1), [last.name] varchar] (50) NOT NULL, [rirst.name] [varchar] (50) NOT NUT.L., number] int NOT NULL GO SELECT FROM Idbo] Ics1101 a) Run the above script to create a table, so you can add records. b) Insert your last namc, first name and number. The number MUST incrcment by 100 on every additional 100 record. For example, look below. First. 100 records (1- 100 Insert. 100 Next. 100 records (101-200) Tnsert. 200 Next. 100 records (201-300)Insert 300 Next 100 records (301 -400 Insert 400 Continue until you have inserted 100,000 records
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
