You just found out that sql server 2008 has spatial support and you want to add a spatail refrence to that the table? Here is how
create TABLE customers ( FirstName nvarchar(30), LatName nvarchar(30) ) alter table customers add location geography
create TABLE customers
(
FirstName nvarchar(30),
LatName nvarchar(30)
)
alter table customers
add location geography
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
© Copyright 2012