Vectors in SQL Server 2025

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

izhar-azati SSC Veteran Points: 273 More actions · Answer 1

some errors:

declare @myvector as vector(3) = '[5, 2, 30, 32]' -- 3 or 4 ?

declare @myvector as vector(3) = JSON_ARRAY(1.0, 2.0, 3.0)
SELECT value AS firstvalue
FROM OPENJSON(CAST(@myvector AS NVARCHAR(MAX)))
WHERE = 0;