Dummy Data for SP Pagination Assigment

CREATE TABLE STUDENT
(
	id int PRIMARY KEY,
	firstName nvarchar(200),
	lastName nvarchar(200),
	email nvarchar(320)
);


-- This is a dummy record do not use in production !!


INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (1,'Candace','Preston','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (2,'Bernard','Kerr','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (3,'Carly','Cherry','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (4,'Clementine','Wise','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (5,'Quamar','Thornton','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (6,'Fleur','Chapman','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (7,'Paloma','Edwards','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (8,'Dorian','Spears','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (9,'Zoe','Jackson','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (10,'Jamal','Rollins','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (11,'Gil','Becker','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (12,'Aiko','Cross','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (13,'Abbot','Nicholson','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (14,'Moana','Tucker','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (15,'TaShya','Wynn','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (16,'Marsden','Barnett','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (17,'Zeph','Schroeder','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (18,'Emily','Blackwell','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (19,'Velma','Sims','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (20,'Tasha','Schneider','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (21,'Lysandra','Harris','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (22,'Robin','Maddox','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (23,'Connor','Potts','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (24,'Michael','Vinson','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (25,'Ava','Mcbride','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (26,'Brandon','Gamble','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (27,'Charde','Boyd','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (28,'Tatum','Durham','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (29,'Price','Horton','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (30,'Brady','Terrell','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (31,'Hall','Finch','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (32,'Kieran','Cruz','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (33,'Aiko','House','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (34,'Astra','Hood','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (35,'TaShya','Santana','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (36,'Stuart','Simon','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (37,'Calista','Hunt','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (38,'Wylie','Mcconnell','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (39,'Lois','Joyce','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (40,'Dane','Chambers','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (41,'Danielle','Kaufman','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (42,'Aline','Tillman','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (43,'Barry','Wright','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (44,'Dalton','Gates','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (45,'Wang','Waters','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (46,'Clio','Delacruz','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (47,'Keegan','Walls','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (48,'Brielle','Rodriguez','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (49,'Audrey','Allen','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (50,'Yoko','Hawkins','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (51,'Tanek','Prince','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (52,'Valentine','Brady','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (53,'Paki','Burton','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (54,'Carla','Farrell','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (55,'Uta','Calderon','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (56,'Russell','Preston','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (57,'Noah','Flowers','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (58,'Bell','Hamilton','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (59,'Logan','Wood','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (60,'Hannah','Blankenship','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (61,'Quentin','Larson','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (62,'Kareem','Hunter','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (63,'Penelope','Cantu','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (64,'Dominique','Buckner','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (65,'Chandler','Barrera','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (66,'Amity','Hayes','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (67,'Dolan','Levine','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (68,'Yardley','Stewart','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (69,'Carolyn','Mcgowan','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (70,'Destiny','Pace','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (71,'Tarik','Keith','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (72,'Ivor','Frost','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (73,'Sarah','Mcclure','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (74,'Shad','Martinez','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (75,'Xavier','Gentry','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (76,'Lacota','Le','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (77,'Kermit','Joyce','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (78,'Shafira','Mays','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (79,'Ray','Walsh','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (80,'Donovan','Chang','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (81,'Caryn','Rodriguez','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (82,'Ryan','Hurst','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (83,'Barclay','Peck','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (84,'Addison','Fowler','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (85,'Merrill','Harrison','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (86,'Leo','Cobb','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (87,'Jade','Rutledge','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (88,'Sharon','Reed','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (89,'Chaney','Phillips','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (90,'Sydney','Baxter','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (91,'Alexandra','Lara','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (92,'Jena','Flynn','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (93,'Austin','Farley','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (94,'Ethan','Collier','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (95,'Cassidy','Hendrix','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (96,'Nehru','Ayala','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (97,'Georgia','Blake','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (98,'Gay','Bernard','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (99,'Thomas','Hebert','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (100,'Myles','Castro','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (101,'Otto','Gamble','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (102,'Keegan','Chapman','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (103,'Jemima','Bauer','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (104,'Zorita','Frederick','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (105,'Phyllis','Ballard','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (106,'Joan','Mcclure','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (107,'Elizabeth','Daugherty','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (108,'Jana','Lawson','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (109,'Joseph','Kline','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (110,'Meredith','Cross','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (111,'David','Daniels','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (112,'Justina','Porter','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (113,'Justina','Hardin','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (114,'Jael','Lynn','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (115,'Jin','Edwards','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (116,'Cally','Olson','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (117,'Colette','Shepherd','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (118,'Clare','Haney','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (119,'Dean','Kidd','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (120,'Nadine','Holman','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (121,'Brody','Serrano','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (122,'Gavin','Glenn','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (123,'Dale','Cooley','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (124,'Ronan','Downs','[email protected]');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (125,'Kalia','Fields','[email protected]');