Skip to main content

Posts

Showing posts from February, 2018

List of Nationality, Countries and Code in SQL Server

Download JSON file - Click on JSON file       AND Download JSON file - Click on Excel file --NATIONALITY TABLE CREATE TABLE [dbo] . [Nationality] (             [NationalityID] [int] IDENTITY ( 1 , 1 ) NOT NULL,             [Country] [nvarchar] ( 55 ) NULL,             [CountryCode] [nvarchar] ( 4 ) NULL,             [Nationality] [nvarchar] ( 140 ) NULL,             [Person] [nvarchar] ( 120 ) NULL ) ON [PRIMARY] GO --INSERT NATIONALITY TABLE INSERT INTO [dbo] . [Nationality] ( Country , CountryCode , Nationality , Person ) VALUES           ( 'UNITED KINGDOM' , 'GB' , 'British' , 'a Briton' ),  ...