Countries MSSQL

Prefabricated/Populated database quires. Prefabricated/populated database tables to help you out. These quires are ready to go. Just simply execute and watch your data populate.
Post Reply
dzcadii
Posts: 94
Joined: Sun Mar 01, 2015 4:36 am

Countries MSSQL

Post by dzcadii » Sun Mar 01, 2015 6:11 pm

Code: Select all

/****** Object:  Table [dbo].[tbl_Countries]    Script Date: 07/26/2013 12:02:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_Countries]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_Countries](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Country] [varchar](500) NOT NULL,
	[Region] [int] NULL,
 CONSTRAINT [PK_tbl_Countries] PRIMARY KEY CLUSTERED 
(
	[Country] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tbl_Countries] ON
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (1, N'Afghanistan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (2, N'Akrotiri', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (3, N'Albania', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (4, N'Algeria', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (5, N'American Samoa', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (6, N'Andorra', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (7, N'Angola', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (8, N'Anguilla', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (9, N'Antarctica', 8)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (10, N'Antigua and Barbuda', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (11, N'Argentina', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (12, N'Armenia', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (13, N'Aruba', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (14, N'Ashmore and Cartier Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (15, N'Australia', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (16, N'Austria', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (17, N'Azerbaijan', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (18, N'Bahamas', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (19, N'Bahrain', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (20, N'Bangladesh', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (21, N'Barbados', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (22, N'Bassas da India', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (23, N'Belarus', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (24, N'Belgium', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (25, N'Belize', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (26, N'Benin', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (27, N'Bermuda', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (28, N'Bhutan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (29, N'Bolivia', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (30, N'Bosnia and Herzegovina', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (31, N'Botswana', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (32, N'Bouvet Island', 8)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (33, N'Brazil', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (34, N'British Indian Ocean Territory', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (35, N'British Virgin Islands', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (36, N'Brunei', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (37, N'Bulgaria', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (38, N'Burkina Faso', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (39, N'Burma (Myanmar)', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (40, N'Burundi', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (41, N'Cambodia', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (42, N'Cameroon', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (43, N'Canada', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (44, N'Cape Verde', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (45, N'Cayman Islands', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (46, N'Central African Republic', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (47, N'Chad', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (48, N'Chile', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (49, N'China', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (50, N'Christmas Island', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (51, N'Clipperton Island', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (52, N'Cocos (Keeling) Islands', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (53, N'Colombia', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (54, N'Comoros', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (57, N'Cook Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (58, N'Coral Sea Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (59, N'Costa Rica', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (60, N'Cote d''Ivoire', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (61, N'Croatia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (62, N'Cuba', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (63, N'Cyprus', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (64, N'Czech Republic', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (55, N'Democratic Republic of the Congo', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (65, N'Denmark', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (66, N'Dhekelia', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (67, N'Djibouti', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (68, N'Dominica', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (69, N'Dominican Republic', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (70, N'Ecuador', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (71, N'Egypt', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (72, N'El Salvador', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (73, N'Equatorial Guinea', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (74, N'Eritrea', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (75, N'Estonia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (76, N'Ethiopia', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (77, N'Europa Island', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (78, N'Falkland Islands (Islas Malvinas)', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (79, N'Faroe Islands', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (155, N'Federated States of Micronesia', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (80, N'Fiji', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (81, N'Finland', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (82, N'France', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (83, N'French Guiana', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (84, N'French Polynesia', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (85, N'French Southern and Antarctic Lands', 8)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (86, N'Gabon', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (87, N'Gambia', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (88, N'Gaza Strip', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (89, N'Georgia', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (90, N'Germany', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (91, N'Ghana', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (92, N'Gibraltar', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (93, N'Glorioso Islands', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (94, N'Greece', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (95, N'Greenland', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (96, N'Grenada', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (97, N'Guadeloupe', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (98, N'Guam', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (99, N'Guatemala', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (100, N'Guernsey', 3)
GO
print 'Processed 100 total records'
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (101, N'Guinea', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (102, N'Guinea-Bissau', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (103, N'Guyana', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (104, N'Haiti', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (105, N'Heard Island and McDonald Islands', 8)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (106, N'Holy See (Vatican City)', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (107, N'Honduras', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (108, N'Hong Kong', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (109, N'Hungary', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (110, N'Iceland', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (111, N'India', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (112, N'Indonesia', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (113, N'Iran', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (114, N'Iraq', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (115, N'Ireland', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (116, N'Isle of Man', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (117, N'Israel', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (118, N'Italy', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (119, N'Jamaica', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (120, N'Jan Mayen', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (121, N'Japan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (122, N'Jersey', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (123, N'Jordan', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (124, N'Juan de Nova Island', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (125, N'Kazakhstan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (126, N'Kenya', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (127, N'Kiribati', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (130, N'Kuwait', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (131, N'Kyrgyzstan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (132, N'Laos', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (133, N'Latvia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (134, N'Lebanon', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (135, N'Lesotho', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (136, N'Liberia', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (137, N'Libya', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (138, N'Liechtenstein', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (139, N'Lithuania', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (140, N'Luxembourg', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (141, N'Macau', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (142, N'Macedonia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (143, N'Madagascar', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (144, N'Malawi', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (145, N'Malaysia', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (146, N'Maldives', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (147, N'Mali', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (148, N'Malta', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (149, N'Marshall Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (150, N'Martinique', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (151, N'Mauritania', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (152, N'Mauritius', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (153, N'Mayotte', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (154, N'Mexico', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (156, N'Moldova', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (157, N'Monaco', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (158, N'Mongolia', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (159, N'Montserrat', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (160, N'Morocco', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (161, N'Mozambique', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (162, N'Namibia', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (163, N'Nauru', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (164, N'Navassa Island', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (165, N'Nepal', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (166, N'Netherlands', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (167, N'Netherlands Antilles', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (168, N'New Caledonia', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (169, N'New Zealand', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (170, N'Nicaragua', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (171, N'Niger', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (172, N'Nigeria', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (173, N'Niue', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (174, N'Norfolk Island', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (128, N'North Korea', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (175, N'Northern Mariana Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (176, N'Norway', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (177, N'Oman', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (178, N'Pakistan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (179, N'Palau', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (180, N'Panama', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (181, N'Papua New Guinea', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (182, N'Paracel Islands', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (183, N'Paraguay', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (184, N'Peru', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (185, N'Philippines', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (186, N'Pitcairn Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (187, N'Poland', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (188, N'Portugal', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (189, N'Puerto Rico', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (190, N'Qatar', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (56, N'Republic of the Congo', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (191, N'Reunion', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (192, N'Romania', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (193, N'Russia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (194, N'Rwanda', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (195, N'Saint Helena', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (196, N'Saint Kitts and Nevis', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (197, N'Saint Lucia', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (198, N'Saint Pierre and Miquelon', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (199, N'Saint Vincent and the Grenadines', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (200, N'Samoa', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (201, N'San Marino', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (202, N'Sao Tome and Principe', 6)
GO
print 'Processed 200 total records'
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (203, N'Saudi Arabia', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (204, N'Senegal', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (205, N'Serbia and Montenegro', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (206, N'Seychelles', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (207, N'Sierra Leone', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (208, N'Singapore', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (209, N'Slovakia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (210, N'Slovenia', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (211, N'Solomon Islands', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (212, N'Somalia', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (213, N'South Africa', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (214, N'South Georgia and the South Sandwich Islands', 8)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (129, N'South Korea', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (215, N'Spain', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (216, N'Spratly Islands', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (217, N'Sri Lanka', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (218, N'Sudan', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (219, N'Suriname', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (220, N'Svalbard', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (221, N'Swaziland', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (222, N'Sweden', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (223, N'Switzerland', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (224, N'Syria', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (225, N'Taiwan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (226, N'Tajikistan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (227, N'Tanzania', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (228, N'Thailand', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (229, N'Timor-Leste', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (230, N'Togo', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (231, N'Tokelau', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (232, N'Tonga', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (233, N'Trinidad and Tobago', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (234, N'Tromelin Island', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (235, N'Tunisia', NULL)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (236, N'Turkey', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (237, N'Turkmenistan', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (238, N'Turks and Caicos Islands', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (239, N'Tuvalu', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (240, N'Uganda', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (241, N'Ukraine', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (242, N'United Arab Emirates', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (243, N'United Kingdom', 3)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (244, N'United States', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (245, N'Uruguay', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (246, N'Uzbekistan', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (247, N'Vanuatu', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (248, N'Venezuela', 2)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (249, N'Vietnam', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (250, N'Virgin Islands', 1)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (251, N'Wake Island', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (252, N'Wallis and Futuna', 7)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (253, N'West Bank', 4)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (254, N'Western Sahara', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (255, N'Yemen', 5)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (256, N'Zambia', 6)
INSERT [dbo].[tbl_Countries] ([id], [Country], [Region]) VALUES (257, N'Zimbabwe', 6)
SET IDENTITY_INSERT [dbo].[tbl_Countries] OFF

Post Reply