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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!