Latest Post
-
-
SQL naar C# class
declare @TableName sysname = ‘V_2021_Dossiers’ declare @Result varchar(max) = ‘public…
-
SQL – Update SRID
update [Tabel].[dbo].[temp] set Geom = geometry::STGeomFromText([Geom].STAsText(), 31370)
-
JSON timestamp naar DateTime
long timestamp = 1598881073211; System.DateTime dtDateTime = new DateTime(1970, 1,…
-
Alle punten van polygoon, met hoogte
DECLARE @max INT SET @max = (SELECT MAX(geom.STNumPoints()) FROM Opmetingen)…
-
Binary Data downloaden uit sql database
USE [POC] DECLARE @outPutPath varchar(50) = ‘C:\G2\My POC\Blog\SQL Server\Extract Blob’…