CREATE TABLE [cgn_canada_shp_eng] ([ID] int IDENTITY(1,1) PRIMARY KEY CLUSTERED, [CGNDB_ID] nvarchar(255), [GEONAME] nvarchar(255), [LANGUAGE] nvarchar(255), [SYLLABIC] nvarchar(255), [GENERIC] nvarchar(255), [CATEGORY] nvarchar(255), [CONCISE] nvarchar(255), [FEATURE_ID] nvarchar(255), [LOCATION] nvarchar(255), [PROV_TERR] nvarchar(255), [REL_SCALE] nvarchar(255), [DECISION] nvarchar(255), [SOURCE] nvarchar(255), [geom] GEOMETRY);

declare @p3 sys.geometry
set @p3=convert(sys.geometry,0x00000000010C5500E720439160C0A0E0ACD227254E40)
exec sp_executesql N'INSERT INTO [cgn_canada_shp_eng] ([geom],"CGNDB_ID","GEONAME","LANGUAGE","SYLLABIC","GENERIC","CATEGORY","CONCISE","FEATURE_ID","LOCATION","PROV_TERR","REL_SCALE","DECISION","SOURCE") VALUES (@GeometryColumn,@CGNDB_ID,@GEONAME,@LANGUAGE,@SYLLABIC,@GENERIC,@CATEGORY,@CONCISE,@FEATURE_ID,@LOCATION,@PROV_TERR,@REL_SCALE,@DECISION,@SOURCE);',N'@GeometryColumn Geometry,@CGNDB_ID nvarchar(5),@GEONAME nvarchar(16),@LANGUAGE nvarchar(7),@SYLLABIC nvarchar(4000),@GENERIC nvarchar(4),@CATEGORY nvarchar(15),@CONCISE nvarchar(3),@FEATURE_ID nvarchar(32),@LOCATION nvarchar(4000),@PROV_TERR nvarchar(5),@REL_SCALE nvarchar(5),@DECISION nvarchar(10),@SOURCE nvarchar(39)',@GeometryColumn=@p3,@CGNDB_ID=N'KAIIZ',@GEONAME=N'Ł''awshà Gúksh',@LANGUAGE=N'Tlingit',@SYLLABIC=N'',@GENERIC=N'Bank',@CATEGORY=N'Terrain Feature',@CONCISE=N'CLF',@FEATURE_ID=N'3b174a38849c20c360738f0df9f9f7e3',@LOCATION=N'',@PROV_TERR=N'Yukon',@REL_SCALE=N'50000',@DECISION=N'2006-05-26',@SOURCE=N'Yukon-Department of Tourism and Culture'