Commit ad83899

authored

updated readme

1 parent 8704a0f commit ad83899Copy full SHA for ad83899

File tree

+15

-1

lines changed

+15

-1

lines changed

Lines changed: 15 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -54,7 +54,21 @@ The native option uses the new Vector Functions, recently introduced in Azur`
`54`	`54`	`> [!NOTE]`
`55`	`55`	`> Vector Functions are in Public Preview. Learn the details about vectors in Azure SQL here: https://aka.ms/azure-sql-vector-public-preview`
`56`	`56`
`57`		`-![](_assets/azure-sql-cosine-similarity-native.gif)`
	`57`	+```sql
	`58`	`+DECLARE @embedding VECTOR(1536)`
	`59`	`+`
	`60`	`+EXEC [web].[get_embedding] 'I want to learn about security in SQL', @embedding OUTPUT`
	`61`	`+`
	`62`	`+SELECT TOP(10)`
	`63`	`+ s.id,`
	`64`	`+ s.title,`
	`65`	`+ s.abstract,`
	`66`	`+ VECTOR_DISTANCE('cosine', @embedding, s.embeddings) AS cosine_distance`
	`67`	`+FROM`
	`68`	`+ [web].[sessions] s`
	`69`	`+ORDER BY`
	`70`	`+ cosine_distance`
	`71`	+```
`58`	`72`
`59`	`73`	`The classic option uses the classic T-SQL to perform vector operations, with the support for columnstore indexes for getting good performances.`
`60`	`74`

-304 KB

Binary file not shown.

Comments

(0)