gist:6167044

CREATE TABLE Content (ContentID varchar(50) NOT NULL, Locale varchar(5) NULL, Value nvarchar(255) NOT NULL)
GO
insert into Content (ContentID, Locale, Content) VALUES ('Welcome','en-us','Welcome to the page. Go USA!')
GO
insert into Content (ContentID, Locale, Content) VALUES ('FirstName','en-us','First Name')
GO
insert into Content (ContentID, Locale, Content) VALUES ('LastName','en-us','Last Name')
GO
insert into Content (ContentID, Locale, Content) VALUES ('Welcome','en-ca','Welcome to the page, eh.')
GO