improved code layout

yorek · yorek · commit 6f407c43de37 · 2023-06-01T10:13:39.000-07:00
diff --git a/vector-embeddings/04-sample-function.sql b/vector-embeddings/04-sample-function.sql
@@ -41,18 +41,3 @@ from
 inner join 
     dbo.wikipedia_articles_embeddings a on r.article_id = a.id
 go
-
-/*
-    Test the function
-*/
-declare @response nvarchar(max);
-declare @payload nvarchar(max) = json_object('input': 'the foundation series by isaac asimov');
-
-exec sp_invoke_external_rest_endpoint
-    @url = 'https:/<your-app-name>.openai.azure.com/openai/deployments/embeddings/embeddings?api-version=2023-03-15-preview',
-    @credential = [https://<your-app-name>.openai.azure.com],
-    @payload = @payload,
-    @response = @response output;
-
-select * from dbo.SimilarContentArticles(json_query(@response, '$.result.data[0].embedding')) as r order by cosine_distance desc
-go
diff --git a/vector-embeddings/05-sample-function-usage.sql b/vector-embeddings/05-sample-function-usage.sql
@@ -0,0 +1,14 @@
+/*
+    Test the function
+*/
+declare @response nvarchar(max);
+declare @payload nvarchar(max) = json_object('input': 'the foundation series by isaac asimov');
+
+exec sp_invoke_external_rest_endpoint
+    @url = 'https://<your-app-name>.openai.azure.com/openai/deployments/embeddings/embeddings?api-version=2023-03-15-preview',
+    @credential = [https://<your-app-name>.openai.azure.com],
+    @payload = @payload,
+    @response = @response output;
+
+select * from dbo.SimilarContentArticles(json_query(@response, '$.result.data[0].embedding')) as r order by cosine_distance desc
+go
