To Create a Spatial Table
CREATE TABLE STREET (ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_STREET_ID PRIMARY KEY, Name VARCHAR(50) NULL, Street_Type VARCHAR(50) NULL, Geom GEOMETRY NULL)
Sample insert statement:
INSERT INTO STREET VALUES ('HIGHWAY 101', 'HIGHWAY', geometry::STLineFromText('LINESTRING(1 5, 21 35)',0))