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','Florence@ullamcorper.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (2,'Bernard','Kerr','Kelly@urna.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (3,'Carly','Cherry','Rogan@dapibus.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (4,'Clementine','Wise','Ulysses@euismod.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (5,'Quamar','Thornton','Ashely@lacinia.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (6,'Fleur','Chapman','Wanda@leo.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (7,'Paloma','Edwards','Matthew@conubia.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (8,'Dorian','Spears','Pandora@amet.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (9,'Zoe','Jackson','Veda@pretium.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (10,'Jamal','Rollins','Katelyn@ad.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (11,'Gil','Becker','Nyssa@ligula.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (12,'Aiko','Cross','Gretchen@magna.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (13,'Abbot','Nicholson','Illana@fermentum.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (14,'Moana','Tucker','Lysandra@Curae.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (15,'TaShya','Wynn','Arden@eget.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (16,'Marsden','Barnett','Paki@nonummy.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (17,'Zeph','Schroeder','Shaine@ridiculus.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (18,'Emily','Blackwell','Charles@cubilia.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (19,'Velma','Sims','Ginger@metus.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (20,'Tasha','Schneider','Jolie@Etiam.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (21,'Lysandra','Harris','Ifeoma@netus.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (22,'Robin','Maddox','Laura@pede.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (23,'Connor','Potts','Francesca@Nam.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (24,'Michael','Vinson','Yen@tincidunt.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (25,'Ava','Mcbride','Riley@ligula.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (26,'Brandon','Gamble','Jacob@Cum.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (27,'Charde','Boyd','Abel@sem.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (28,'Tatum','Durham','Ian@sed.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (29,'Price','Horton','Armand@metus.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (30,'Brady','Terrell','Alexis@penatibus.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (31,'Hall','Finch','Micah@Sed.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (32,'Kieran','Cruz','Hyatt@faucibus.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (33,'Aiko','House','Baker@justo.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (34,'Astra','Hood','Ivy@ultrices.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (35,'TaShya','Santana','Griffin@Phasellus.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (36,'Stuart','Simon','Quinlan@Vestibulum.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (37,'Calista','Hunt','Sybill@id.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (38,'Wylie','Mcconnell','Hyacinth@parturient.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (39,'Lois','Joyce','Steven@Fusce.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (40,'Dane','Chambers','Rylee@blandit.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (41,'Danielle','Kaufman','Olga@aptent.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (42,'Aline','Tillman','Rina@condimentum.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (43,'Barry','Wright','Myra@sociis.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (44,'Dalton','Gates','Orli@vitae.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (45,'Wang','Waters','Wendy@dignissim.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (46,'Clio','Delacruz','Mira@Pellentesque.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (47,'Keegan','Walls','Miriam@auctor.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (48,'Brielle','Rodriguez','Dale@dis.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (49,'Audrey','Allen','MacKensie@nunc.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (50,'Yoko','Hawkins','Howard@est.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (51,'Tanek','Prince','Porter@Cras.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (52,'Valentine','Brady','Stephen@conubia.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (53,'Paki','Burton','Slade@quis.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (54,'Carla','Farrell','Zeus@commodo.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (55,'Uta','Calderon','James@vel.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (56,'Russell','Preston','Savannah@convallis.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (57,'Noah','Flowers','Duncan@Proin.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (58,'Bell','Hamilton','Riley@vitae.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (59,'Logan','Wood','Linus@erat.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (60,'Hannah','Blankenship','Emerson@nisi.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (61,'Quentin','Larson','Logan@faucibus.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (62,'Kareem','Hunter','Tallulah@aliquam.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (63,'Penelope','Cantu','Blaze@elementum.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (64,'Dominique','Buckner','Tanner@rutrum.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (65,'Chandler','Barrera','Kristen@inceptos.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (66,'Amity','Hayes','Galvin@mauris.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (67,'Dolan','Levine','Wynter@ut.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (68,'Yardley','Stewart','Kyra@porttitor.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (69,'Carolyn','Mcgowan','Ora@ac.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (70,'Destiny','Pace','Rhiannon@commodo.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (71,'Tarik','Keith','Vance@pellentesque.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (72,'Ivor','Frost','Liberty@Nam.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (73,'Sarah','Mcclure','Brooke@pharetra.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (74,'Shad','Martinez','Ali@vestibulum.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (75,'Xavier','Gentry','Tobias@Vestibulum.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (76,'Lacota','Le','Raja@augue.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (77,'Kermit','Joyce','Ignacia@facilisis.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (78,'Shafira','Mays','Beverly@natoque.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (79,'Ray','Walsh','Fatima@ad.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (80,'Donovan','Chang','Constance@urna.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (81,'Caryn','Rodriguez','Rhiannon@Etiam.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (82,'Ryan','Hurst','Denise@Proin.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (83,'Barclay','Peck','Victor@varius.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (84,'Addison','Fowler','Uriel@hendrerit.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (85,'Merrill','Harrison','Xantha@Etiam.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (86,'Leo','Cobb','Mufutau@porttitor.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (87,'Jade','Rutledge','Sybil@ultricies.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (88,'Sharon','Reed','Eagan@imperdiet.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (89,'Chaney','Phillips','Ocean@quam.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (90,'Sydney','Baxter','Wylie@dictum.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (91,'Alexandra','Lara','Alfonso@natoque.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (92,'Jena','Flynn','Trevor@Aliquam.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (93,'Austin','Farley','Clayton@sit.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (94,'Ethan','Collier','Hyatt@penatibus.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (95,'Cassidy','Hendrix','Ryder@pulvinar.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (96,'Nehru','Ayala','Shaine@augue.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (97,'Georgia','Blake','Alexander@sit.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (98,'Gay','Bernard','Fritz@varius.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (99,'Thomas','Hebert','Len@Aliquam.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (100,'Myles','Castro','Jerome@convallis.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (101,'Otto','Gamble','Dorothy@fringilla.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (102,'Keegan','Chapman','Carol@volutpat.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (103,'Jemima','Bauer','Duncan@purus.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (104,'Zorita','Frederick','Axel@Mauris.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (105,'Phyllis','Ballard','Aladdin@nec.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (106,'Joan','Mcclure','Yetta@leo.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (107,'Elizabeth','Daugherty','Ferdinand@ipsum.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (108,'Jana','Lawson','Lamar@pede.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (109,'Joseph','Kline','Odysseus@sagittis.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (110,'Meredith','Cross','Noah@litora.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (111,'David','Daniels','Levi@mus.com');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (112,'Justina','Porter','Kyla@Cras.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (113,'Justina','Hardin','Jamalia@id.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (114,'Jael','Lynn','Carla@rhoncus.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (115,'Jin','Edwards','Eaton@ultricies.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (116,'Cally','Olson','Noel@lacinia.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (117,'Colette','Shepherd','Lionel@imperdiet.org');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (118,'Clare','Haney','Alma@sapien.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (119,'Dean','Kidd','Holly@interdum.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (120,'Nadine','Holman','Dillon@elementum.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (121,'Brody','Serrano','Sierra@In.edu');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (122,'Gavin','Glenn','Honorato@Pellentesque.us');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (123,'Dale','Cooley','Adrian@nisi.gov');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (124,'Ronan','Downs','Judah@ridiculus.net');
INSERT INTO student ([id],[firstName],[lastName],[email]) VALUES (125,'Kalia','Fields','Knox@scelerisque.org');