SQL Server spatial data type, draw a graph from the Management studio
Hi Guys! Today we talk about spatial data type. We will see how to draw a graph directly from SQL Server Management Studio Are you ready to see new datatype called Spatial data type? Yes? OK! So, i will try to explain as simply as possible. Introduction Spatial data type are datatypes used for conserving spatial data which allows us to render graphical data. They are used for representing the location, size, and shape of an object. Every object such as lake or a car could be rapresented. Spatial data may also include attributes which can be given more information of the entity that is being represented. That there are two types of spatial data: Geometry or Geography . Today we will examine Geometry spatial data type. How to use Spatial geometry data type We can define a spatial data type like any other data type. For example we can create a table where a column (GEOM) is defined as geometry. CREATE TABLE [dbo].[SPATIAL_TABLE]( [ID] [in...