versago3:dataview_setup
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
versago3:dataview_setup [2023/07/14 12:36] dlee [Stored Procedure] |
versago3:dataview_setup [2023/07/14 12:38] (current) dlee [Stored Procedure] |
||
|---|---|---|---|
| Line 64: | Line 64: | ||
| Store procedure parameters must be configured in the **// | Store procedure parameters must be configured in the **// | ||
| - | === Stored Procedure Limitations | + | |
| + | <WRAP center round important 100% > | ||
| + | **Stored Procedure Limitations** | ||
| + | </ | ||
| Versago uses the view sys.dm_exec_describe_first_result_set_for_object to determine the store procedure' | Versago uses the view sys.dm_exec_describe_first_result_set_for_object to determine the store procedure' | ||
| However, there are limitations with the system view that restricts the use of some store procedures in Versago. | However, there are limitations with the system view that restricts the use of some store procedures in Versago. | ||
| Line 72: | Line 75: | ||
| < | < | ||
| - | SELECT name, system_type_name FROM sys.dm_exec_describe_first_result_set_for_object(OBJECT_ID(@StoredProcedureName), | + | SELECT name, system_type_name |
| + | FROM sys.dm_exec_describe_first_result_set_for_object(OBJECT_ID(@StoredProcedureName), | ||
| </ | </ | ||
| + | |||
| + | |||
| ====View==== | ====View==== | ||
versago3/dataview_setup.1689352603.txt.gz · Last modified: 2023/07/14 12:36 by dlee
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
