--sadly the create table statement has to be at the start of a batch CREATE TABLE dbo.Location ( TheLanguage NVARCHAR(30) NOT NULL, Description VARCHAR(100) NOT NULL DEFAULT '', CONSTRAINT LanguageKey PRIMARY KEY (TheLanguage) ); --now we insert the row we need ...