Skip to content

Instantly share code, notes, and snippets.

Bubblan pRob3

Block or report user

Report or block pRob3

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@pRob3
pRob3 / Countries.sql
Last active May 10, 2018
Sql dump of all the Countries, Country Codes, Phone codes. (MSSQL) .
View Countries.sql
-- Check i table exists else create it
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[Country]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].Country(
Id int NOT NULL IDENTITY(1,1) PRIMARY KEY,
Iso char(2) NOT NULL,
Name varchar(80) NOT NULL,
NiceName varchar(80) NOT NULL,
You can’t perform that action at this time.