Spatial data in SQL database

It’s possible to store spatial data in an SQL database like this…

create table TestTable
(
	Geo Geography,
	DateStamp SmallDateTime,
	Data float
)


insert into TestTable
values(
geography::Parse('POINT(-2.25 51.55)'),
'2016-10-23 08:00',
1243
)

select
Geo.Lat,
Geo.Long,
*
from TestTable