UPDATE [MarvelTour_DEV].[dbo].[LocationCopy]

SET

LocationGeography = geography::STGeomFromText('POINT('+CAST(@Longitude AS Varchar)+' '+CAST(@Latitude AS Varchar)+')', 4326)

WHERE LocationID = @ID

So these methods only take Varchar datat type only after converting to varchar it is working

Thanks