You should create a GEOMETRY data type column in your table to store the coordinates as spatial objects.
And I'll assume you have your coordinate pair values in columns called LAT and LON... and I'm naming your source and destination columns arbitrarily based on your data above...see the SQL below.
You should be able to do this:
alter table LOT_EXPLOITATION_LOT
add column geom geometry
Then when you insert the points, you can insert them into the GEOG column as spatial data by using the STGeomFromText function - you also want to use the correct syntax for the INSERT as well, so It might look something like this:
INSERT INTO LOT_EXPLOITATION_LOT
(dest_column1
, dest_column2
, dest_column3
, dest_column4
, dest_column5
, geom)
select
source_column1
, source_column2
, source_column3
, source_column4
, source_column5
, geometry::STGeomFromText('POINT('+convert(varchar(20),data.lon)+' '+convert(varchar(20),data.lat)+')',4326) as geom
4326 is the SRID (coordinate system) for your data as it looks like it's in decimal degrees... is that correct?
Anyway, let me know what you think.
Some would also say to use the GEOGRAPHY data type for your data as it is in decimal degrees - Geometry also works for decimal degree data as far as I know.