Differences

This shows you the differences between two versions of the page.

--- versago3:dataview_setup [2022/09/08 12:57]
dlee
+++ versago3:dataview_setup [2023/07/14 12:38] (current)
dlee [Stored Procedure]
@@ Line 63: / Line 63: @@
 Store procedure parameters must be configured in the **//[[versago3:dataview_filters|Filters]]//** page.
+<WRAP center round important 100% >
+**Stored Procedure Limitations**
+</WRAP>
+Versago uses the view sys.dm_exec_describe_first_result_set_for_object to determine the store procedure's result set schema.
+However, there are limitations with the system view that restricts the use of some store procedures in Versago.
+The limitations include the use of temp tables and dynamic sql in the store procedure.
+Use the following query to determine if your store procedure will be suitable to be used as a Versago data source:
+<code>
+SELECT name, system_type_name
+FROM sys.dm_exec_describe_first_result_set_for_object(OBJECT_ID(@StoredProcedureName), 0)
+</code>
 ====View====
@@ Line 100: / Line 117: @@
 ----
-**[[versago3:dataview#Add/Edit Data View/Add Edit Data View]]**
+**[[versago3:dataview#Add/Edit Data View]]**
 **[[versago3:Home|Home]]**

Wiki