Classic ASP - Classic ASP Column & Paging System : Code Entry

Live Editing Disabled for Server-Side Example

HTML

<!--#include file="Header.asp"-->
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
<title> Pagination is Classic ASP - EE's very own Carrzkiss</title>
<link href="TheListPaging.css" rel="stylesheet" type="text/css" />
</head>

<body>
<%
' Updated on 9/28/2022
' Changed from using a <table> to using a <div> Grid.
%>
<%
' Check to see if there are any records to display. If there are none, show a message; otherwise, let users know how many records are available.
    if rsSearch.eof then%>
    Sorry, there are no records available
    <%else%>
   Showing page <strong><%=CurrentPage%> </strong> of <strong><%=TotalPages%> </strong>: Total of Records: <strong><%=Number%> </strong>
<div class="grid-container"> 
<div class="grid-item id">ID</div>
<div class="grid-item FName">First Name</div>
<div class="grid-item LName">Last Name</div>

    <%
    While Not rsSearch.EOF and Count < rsSearch.PageSize
    count = count + 1
    
    ' If we have records, then display them using the Variables listed below.
    if not rsSearch.eof then
    ID = rsSearch("id")
    fname = rsSearch("first_name")
    lname = rsSearch("last_name")
    end if
    %>
    
    <%' This is where your Table of records goes %>
<div class="grid-item id"><%=ID%></div>
<div class="grid-item FName"><%=fname%></div>
<div class="grid-item LName"><%=lname%></div>    
    <%rsSearch.movenext
wend%>
</div>
<!--#include file="Paging.asp"-->
</body></html>

CSS

@charset "utf-8";
/*This is for the paging.*/
#Paging {
    margin:2.5px 0 0 0;
    padding:2.5px 0 2.5px 0;
}
#Paging .One {
    border:1px double #000;
    background-color:#036;
    color:#FFF;
    padding:4.5px; /*Make the selected number container larger then those around it.*/
    font-size:10pt;
}
#Paging .NotOne {
    border:1px double #000;
    padding:2.5px;
    font-size:10pt;
}
#Paging .Numbered {
    border:1px double #000;
    padding:2.5px;
    font-size:10pt;
}
#Paging .Dots {
    font-size:12px;
    background-color: #f1f1f1;
    color: black;
    border:1px double #000;
    padding:5px;
}
.StraightLined {
    display: inline;
}

body{
    background-color:#000;
    color:#D6D6D6;
    width:95%;
}
a:link, a:link font, a:active, a:active font, a:visited, a:visited font{
  font-family: Arial; 
  font-size: 12px; 
  color:#666666;
  text-decoration: none; 
}
a:hover{
text-decoration:overline underline;
}
.tdID{
    text-align:left;
    vertical-align:top;
    border:1px #333 double;
    width:50px;
}
.tdRound{
    text-align:left;
    vertical-align:top;
    border:1px #333 double;
    width:150px;
}

/*Let's set the page to the center. It just looks more professional than having it set alLeft or alRight*/
#MainDiv{
    margin-left:auto;
    margin-right:auto;
    width:600px;
}

SQL

USE [Virtual-Class-01]
GO
/****** Object:  Table [dbo].[NamesList]    Script Date: 9/28/2022 10:26:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NamesList](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [first_name] [nvarchar](50) NOT NULL,
    [last_name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_NamesList] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[NamesList] ON 
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (1, N'first_name', N'last_name')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (2, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (3, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (4, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (5, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (6, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (7, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (8, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (9, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (10, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (11, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (12, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (13, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (14, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (15, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (16, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (17, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (18, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (19, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (20, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (21, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (22, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (23, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (24, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (25, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (26, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (27, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (28, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (29, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (30, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (31, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (32, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (33, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (34, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (35, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (36, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (37, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (38, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (39, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (40, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (41, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (42, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (43, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (44, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (45, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (46, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (47, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (48, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (49, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (50, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (51, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (52, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (53, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (54, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (55, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (56, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (57, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (58, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (59, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (60, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (61, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (62, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (63, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (64, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (65, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (66, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (67, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (68, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (69, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (70, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (71, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (72, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (73, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (74, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (75, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (76, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (77, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (78, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (79, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (80, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (81, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (82, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (83, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (84, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (85, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (86, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (87, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (88, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (89, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (90, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (91, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (92, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (93, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (94, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (95, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (96, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (97, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (98, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (99, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (100, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (101, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (102, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (103, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (104, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (105, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (106, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (107, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (108, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (109, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (110, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (111, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (112, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (113, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (114, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (115, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (116, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (117, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (118, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (119, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (120, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (121, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (122, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (123, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (124, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (125, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (126, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (127, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (128, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (129, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (130, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (131, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (132, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (133, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (134, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (135, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (136, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (137, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (138, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (139, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (140, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (141, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (142, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (143, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (144, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (145, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (146, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (147, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (148, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (149, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (150, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (151, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (152, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (153, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (154, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (155, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (156, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (157, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (158, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (159, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (160, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (161, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (162, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (163, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (164, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (165, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (166, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (167, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (168, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (169, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (170, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (171, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (172, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (173, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (174, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (175, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (176, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (177, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (178, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (179, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (180, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (181, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (182, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (183, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (184, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (185, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (186, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (187, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (188, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (189, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (190, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (191, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (192, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (193, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (194, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (195, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (196, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (197, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (198, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (199, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (200, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (201, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (202, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (203, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (204, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (205, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (206, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (207, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (208, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (209, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (210, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (211, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (212, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (213, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (214, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (215, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (216, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (217, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (218, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (219, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (220, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (221, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (222, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (223, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (224, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (225, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (226, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (227, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (228, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (229, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (230, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (231, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (232, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (233, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (234, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (235, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (236, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (237, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (238, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (239, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (240, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (241, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (242, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (243, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (244, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (245, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (246, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (247, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (248, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (249, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (250, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (251, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (252, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (253, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (254, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (255, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (256, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (257, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (258, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (259, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (260, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (261, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (262, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (263, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (264, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (265, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (266, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (267, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (268, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (269, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (270, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (271, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (272, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (273, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (274, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (275, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (276, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (277, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (278, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (279, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (280, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (281, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (282, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (283, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (284, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (285, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (286, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (287, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (288, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (289, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (290, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (291, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (292, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (293, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (294, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (295, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (296, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (297, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (298, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (299, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (300, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (301, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (302, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (303, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (304, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (305, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (306, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (307, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (308, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (309, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (310, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (311, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (312, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (313, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (314, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (315, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (316, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (317, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (318, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (319, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (320, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (321, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (322, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (323, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (324, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (325, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (326, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (327, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (328, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (329, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (330, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (331, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (332, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (333, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (334, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (335, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (336, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (337, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (338, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (339, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (340, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (341, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (342, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (343, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (344, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (345, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (346, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (347, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (348, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (349, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (350, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (351, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (352, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (353, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (354, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (355, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (356, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (357, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (358, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (359, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (360, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (361, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (362, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (363, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (364, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (365, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (366, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (367, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (368, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (369, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (370, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (371, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (372, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (373, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (374, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (375, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (376, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (377, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (378, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (379, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (380, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (381, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (382, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (383, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (384, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (385, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (386, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (387, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (388, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (389, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (390, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (391, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (392, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (393, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (394, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (395, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (396, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (397, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (398, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (399, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (400, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (401, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (402, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (403, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (404, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (405, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (406, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (407, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (408, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (409, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (410, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (411, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (412, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (413, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (414, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (415, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (416, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (417, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (418, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (419, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (420, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (421, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (422, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (423, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (424, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (425, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (426, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (427, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (428, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (429, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (430, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (431, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (432, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (433, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (434, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (435, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (436, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (437, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (438, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (439, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (440, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (441, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (442, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (443, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (444, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (445, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (446, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (447, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (448, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (449, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (450, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (451, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (452, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (453, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (454, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (455, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (456, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (457, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (458, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (459, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (460, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (461, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (462, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (463, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (464, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (465, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (466, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (467, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (468, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (469, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (470, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (471, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (472, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (473, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (474, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (475, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (476, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (477, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (478, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (479, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (480, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (481, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (482, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (483, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (484, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (485, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (486, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (487, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (488, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (489, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (490, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (491, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (492, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (493, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (494, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (495, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (496, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (497, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (498, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (499, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (500, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (501, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (502, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (503, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (504, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (505, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (506, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (507, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (508, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (509, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (510, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (511, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (512, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (513, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (514, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (515, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (516, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (517, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (518, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (519, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (520, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (521, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (522, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (523, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (524, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (525, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (526, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (527, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (528, N'Shoaib', N'Malik')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (529, N'Saeed', N'Anwar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (530, N'Shahid', N'Afridi')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (531, N'Imran', N'Nazir')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (532, N'Younis', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (533, N'Inzamam', N'Ul-Haq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (534, N'Yousuf', N'Youhana')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (535, N'Wasim', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (536, N'Moin', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (537, N'Abdul', N'Razzaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (538, N'Azhar', N'Mahmood')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (539, N'Saqlain', N'Mushtaq')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (540, N'Arshad', N'Khan')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (541, N'Waqar', N'Younis')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (542, N'Shoaib', N'Akhtar')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (543, N'Mohammad', N'Akram')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (544, N'Shabbir', N'Ahmad')
GO
INSERT [dbo].[NamesList] ([ID], [first_name], [last_name]) VALUES (545, N'Shoaib', N'Malik')
GO
SET IDENTITY_INSERT [dbo].[NamesList] OFF
GO

Classic ASP

<%
'--------------------------------------------------------------------
' Microsoft ADO
' (c) 1996 Microsoft Corporation. All Rights Reserved.
' ADO constants include file for VBScript.
'--------------------------------------------------------------------
'---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3

'---- CursorOptionEnum Values ----
Const adHoldRecords = &H00000100
Const adMovePrevious = &H00000200
Const adAddNew = &H01000400
Const adDelete = &H01000800
Const adUpdate = &H01008000
Const adBookmark = &H00002000
Const adApproxPosition = &H00004000
Const adUpdateBatch = &H00010000
Const adResync = &H00020000
Const adNotify = &H00040000

'---- LockTypeEnum Values ----
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4

'---- ExecuteOptionEnum Values ----
Const adRunAsync = &H00000010

'---- ObjectStateEnum Values ----
Const adStateClosed = &H00000000
Const adStateOpen = &H00000001
Const adStateConnecting = &H00000002
Const adStateExecuting = &H00000004

'---- CursorLocationEnum Values ----
Const adUseServer = 2
Const adUseClient = 3

'---- DataTypeEnum Values ----
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205

'---- FieldAttributeEnum Values ----
Const adFldMayDefer = &H00000002
Const adFldUpdatable = &H00000004
Const adFldUnknownUpdatable = &H00000008
Const adFldFixed = &H00000010
Const adFldIsNullable = &H00000020
Const adFldMayBeNull = &H00000040
Const adFldLong = &H00000080
Const adFldRowID = &H00000100
Const adFldRowVersion = &H00000200
Const adFldCacheDeferred = &H00001000

'---- EditModeEnum Values ----
Const adEditNone = &H0000
Const adEditInProgress = &H0001
Const adEditAdd = &H0002
Const adEditDelete = &H0004

'---- RecordStatusEnum Values ----
Const adRecOK = &H0000000
Const adRecNew = &H0000001
Const adRecModified = &H0000002
Const adRecDeleted = &H0000004
Const adRecUnmodified = &H0000008
Const adRecInvalid = &H0000010
Const adRecMultipleChanges = &H0000040
Const adRecPendingChanges = &H0000080
Const adRecCanceled = &H0000100
Const adRecCantRelease = &H0000400
Const adRecConcurrencyViolation = &H0000800
Const adRecIntegrityViolation = &H0001000
Const adRecMaxChangesExceeded = &H0002000
Const adRecObjectOpen = &H0004000
Const adRecOutOfMemory = &H0008000
Const adRecPermissionDenied = &H0010000
Const adRecSchemaViolation = &H0020000
Const adRecDBDeleted = &H0040000

'---- GetRowsOptionEnum Values ----
Const adGetRowsRest = -1

'---- PositionEnum Values ----
Const adPosUnknown = -1
Const adPosBOF = -2
Const adPosEOF = -3

'---- enum Values ----
Const adBookmarkCurrent = 0
Const adBookmarkFirst = 1
Const adBookmarkLast = 2

'---- MarshalOptionsEnum Values ----
Const adMarshalAll = 0
Const adMarshalModifiedOnly = 1

'---- AffectEnum Values ----
Const adAffectCurrent = 1
Const adAffectGroup = 2
Const adAffectAll = 3

'---- FilterGroupEnum Values ----
Const adFilterNone = 0
Const adFilterPendingRecords = 1
Const adFilterAffectedRecords = 2
Const adFilterFetchedRecords = 3
Const adFilterPredicate = 4

'---- SearchDirection Values ----
Const adSearchForward = 1
Const adSearchBackward = -1

'---- ConnectPromptEnum Values ----
Const adPromptAlways = 1
Const adPromptComplete = 2
Const adPromptCompleteRequired = 3
Const adPromptNever = 4

'---- ConnectModeEnum Values ----
Const adModeUnknown = 0
Const adModeRead = 1
Const adModeWrite = 2
Const adModeReadWrite = 3
Const adModeShareDenyRead = 4
Const adModeShareDenyWrite = 8
Const adModeShareExclusive = &Hc
Const adModeShareDenyNone = &H10

'---- IsolationLevelEnum Values ----
Const adXactUnspecified = &Hffffffff
Const adXactChaos = &H00000010
Const adXactReadUncommitted = &H00000100
Const adXactBrowse = &H00000100
Const adXactCursorStability = &H00001000
Const adXactReadCommitted = &H00001000
Const adXactRepeatableRead = &H00010000
Const adXactSerializable = &H00100000
Const adXactIsolated = &H00100000

'---- XactAttributeEnum Values ----
Const adXactCommitRetaining = &H00020000
Const adXactAbortRetaining = &H00040000

'---- PropertyAttributesEnum Values ----
Const adPropNotSupported = &H0000
Const adPropRequired = &H0001
Const adPropOptional = &H0002
Const adPropRead = &H0200
Const adPropWrite = &H0400

'---- ErrorValueEnum Values ----
Const adErrInvalidArgument = &Hbb9
Const adErrNoCurrentRecord = &Hbcd
Const adErrIllegalOperation = &Hc93
Const adErrInTransaction = &Hcae
Const adErrFeatureNotAvailable = &Hcb3
Const adErrItemNotFound = &Hcc1
Const adErrObjectInCollection = &Hd27
Const adErrObjectNotSet = &Hd5c
Const adErrDataConversion = &Hd5d
Const adErrObjectClosed = &He78
Const adErrObjectOpen = &He79
Const adErrProviderNotFound = &He7a
Const adErrBoundToCommand = &He7b
Const adErrInvalidParamInfo = &He7c
Const adErrInvalidConnection = &He7d
Const adErrStillExecuting = &He7f
Const adErrStillConnecting = &He81

'---- ParameterAttributesEnum Values ----
Const adParamSigned = &H0010
Const adParamNullable = &H0040
Const adParamLong = &H0080

'---- ParameterDirectionEnum Values ----
Const adParamUnknown = &H0000
Const adParamInput = &H0001
Const adParamOutput = &H0002
Const adParamInputOutput = &H0003
Const adParamReturnValue = &H0004

'---- CommandTypeEnum Values ----
Const adCmdUnknown = &H0008
Const adCmdText = &H0001
Const adCmdTable = &H0002
Const adCmdStoredProc = &H0004

'---- SchemaEnum Values ----
Const adSchemaProviderSpecific = -1
Const adSchemaAsserts = 0
Const adSchemaCatalogs = 1
Const adSchemaCharacterSets = 2
Const adSchemaCollations = 3
Const adSchemaColumns = 4
Const adSchemaCheckConstraints = 5
Const adSchemaConstraintColumnUsage = 6
Const adSchemaConstraintTableUsage = 7
Const adSchemaKeyColumnUsage = 8
Const adSchemaReferentialContraints = 9
Const adSchemaTableConstraints = 10
Const adSchemaColumnsDomainUsage = 11
Const adSchemaIndexes = 12
Const adSchemaColumnPrivileges = 13
Const adSchemaTablePrivileges = 14
Const adSchemaUsagePrivileges = 15
Const adSchemaProcedures = 16
Const adSchemaSchemata = 17
Const adSchemaSQLLanguages = 18
Const adSchemaStatistics = 19
Const adSchemaTables = 20
Const adSchemaTranslations = 21
Const adSchemaProviderTypes = 22
Const adSchemaViews = 23
Const adSchemaViewColumnUsage = 24
Const adSchemaViewTableUsage = 25
Const adSchemaProcedureParameters = 26
Const adSchemaForeignKeys = 27
Const adSchemaPrimaryKeys = 28
Const adSchemaProcedureColumns = 29
%>

<%
getServer = "sqlcorecs-01"
getInstance = "sql2019"
getID = "testuser"
getPW = "testuser"
csurl = "www.cffcs.com"

Set objConn = CreateObject("ADODB.Connection")
objConn.Open("Provider=SQLOLEDB; Data Source="&getServer&"\"&getInstance&"; Initial Catalog=Virtual-Class-01;User ID="&getID&";Password="&getPW&";")
%>

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%' Code Written by Wayne Barron aka Carrzkiss of Carrz-Fox-Fire Promotions
' Original Code was written on: 11/16/2010
' Updated Code was written on: 7/7/2012


'=-=-=-=-=-=-=-=-=Updated code written on: 9/28/2022=-=-=-=-=-=-=-=-=
' Moved Header ASP Code into the header.asp page.
' SQL Server connection and Database script in ACN.asp (Removed Access Database connections and samples)
' Changed to our default Paging links script.
'=-=-=-=-=-=-=-=-=Updated Info Ending 9/28/2022=-=-=-=-=-=-=-=-=-=-=-=

' The line at the very top of the page <%@
' Only 1 @ can be on a page, and it HAS to be located at the very top of the top, on top of all other code and includes.

'First, we need to invoke the ADOVBS.inc file; this is needed for the adUserClient to work without error.
' You also want to use this for helping to protect your code.%>
<!--#include file="ADOVBS.inc"-->
<!--#include file="ACN.asp"-->
<%

' Here we are creating our Command object.
Set searchsql = CreateObject("ADODB.Command")
searchsql.ActiveConnection=objConn
searchsql.Prepared = true
Set rsSearch=Server.CreateObject("ADODB.RecordSet")
' To change the number of records that are displayed, change the
' NumPerPage = 10  <== Change this # to the value you want to display
if request("NumPerPage") <> 0 Then NumPerPage = Int(request("NumPerPage")) Else NumPerPage = 10 end if
searchsql.commandtext="SELECT id, first_name, last_name FROM NamesList"

 if Request.QueryString("page") = "" Then
    CurrentPage = 1 'We're On the first page
    NumPerPageOf = 1
    Else
    CurrentPage = CInt(Request.QueryString("page"))
    NumPerPageOf = ((CurrentPage * NumPerPage) - NumPerPage) + 1
    End if
rsSearch.CursorLocation = adUseClient
rsSearch.CursorType = adOpenKeyset 
rsSearch.LockType = adLockreadonly
rsSearch.open searchsql 
    
    Number = rsSearch.RecordCount
    if Not rsSearch.EOF Then
        rsSearch.MoveFirst
        rsSearch.PageSize = NumPerPage
    TotalPages = rsSearch.PageCount
    rsSearch.AbsolutePage = CurrentPage
    End if
    ScriptName = request.servervariables("ScriptName")
    
    cs = 1
%>

<ol id="Paging">
    <%if Not CurrentPage = 1 Then
    'This is the beginning, to jump to the start.
    '%>
    <li class="StraightLined">
    <a itemprop="url" rel="prev" href="<%=ScriptName%>?<%=whatLink%>&NumPerPage=<%=NumPerPage%>&page=<%=CurrentPage - 1%><%=theTab%>">
    <span class="Dots"><strong>« <%'Previous%></strong></span></a>
    </li>
    <% if CurrentPage > 5 and TotalPages > 10 Then%>
   <li class="StraightLined"> 
   <a itemprop="url" href="<%=ScriptName%>?<%=whatLink%>&NumPerPage=<%=NumPerPage%>&page=1<%=theTab%>">
   <span class="NotOne"><strong>1</strong></span></a><span class="Dots"><strong> ... </strong></span>
   </li>
    <%
    End if
    
    if TotalPages > 10 Then
        
        if CurrentPage > 5 Then
            if TotalPages > (CurrentPage + 5) Then
                ini = (CurrentPage - 4)
                fim = (CurrentPage + 5)
            Else
                ini = (TotalPages - 9)
                fim = TotalPages
            End if 
        Else
            ini = 1
            fim = 10
        End if
        
    else
    ini=1
    fim = TotalPages
    End if
    For a = ini To fim
    
    ' here, we will check if the page is before or after, so we can add the REL=PREV or REL=NEXT for the navigation.
    if a <Cint(request("page")) then
    tehRel =  "rel=""prev"""
    elseif a > Cint(request("page")) then
    tehRel =  "rel=""next"""
    end if
    if a = Cint(request("page")) Then
    ' This is the CURRENT page we are on.
    %>
    <li class="StraightLined"><span class="One"><strong><%=a%></strong></span></li>
    <% Else 
    ' This is the next and previous page?? WHY??%>
   <li class="StraightLined">
   <a itemprop="url" <%=tehRel%> href="<%=ScriptName%>?<%=whatLink%>&NumPerPage=<%=NumPerPage%>&page=<%=a%><%=theTab%>">
   <span class="Numbered"><strong><%=a%></strong></span></a>
   </li>
    <%
    End if
    Next
    Else
        if TotalPages = 1 Then
                Response.write ""
            Else
                ' This is the FIRST page!!!
                %>
   <li class="StraightLined"> <span class="One"><strong>1</strong></span></li>
    <%
        End if
        if TotalPages > 10 Then
        fim = 10
        Else
        fim = TotalPages
        End if
        For a = 2 To fim
    if a = Cint(request("page")) Then%>
   <li class="StraightLined"> <span class="One"><strong><%=a%></strong></span></li>
    <% Else %>
   <li class="StraightLined"> 
   <a itemprop="url" rel="next" href="<%=ScriptName%>?<%=whatLink%>&NumPerPage=<%=NumPerPage%>&page=<%=a%><%=theTab%>">
   <span class="Numbered"><strong><%=a%></strong></span>
   </a>
   </li>
    <%
    End if
    Next
    End if
    if CurrentPage < TotalPages - 5 and TotalPages > 10 Then
    ' The last ...   [NUMBER]  ...
    %>
    <li class="StraightLined">
    <span class="Dots"><strong> ... </strong></span>
    <a itemprop="url" href="<%=ScriptName%>?<%=whatLink%>&NumPerPage=<%=NumPerPage%>&page=<%=TotalPages%><%=theTab%>">
    <span class="Numbered"><%=TotalPages%></strong></span>
    </a>
    </li>
    <% End if
    'Display NEXT page link, if appropriate
    if not CurrentPage = TotalPages Then%>
    <li class="StraightLined">
    <a itemprop="url" rel="next" href="<%=ScriptName%>?<%=whatLink%>&NumPerPage=<%=NumPerPage%>&page=<%=CurrentPage + 1%><%=theTab%>">
    <span class="Dots"><strong> <%'Next%> » </strong></span>
    </a>
    </li>
    <%end if%>
     </ol><%end if%>

Preview