Is it possible to call stored procedure in a view?

Question

Answers. No, but most-likely you can convert your stored procedure to a table-valued function.Then you can call the table-valued function in a view. The inline function will frequently provide more options to the optimizer than an multi-line function provides and will frequently optimize better. 5 мая 2008 г.

Can we call view in stored procedure in SQL Server?

First, we will create a stored procedure in SQL Server Database. Second, enable the Data Access on the SQL Server instance. Third, create a view that uses the stored procedure. In the end, we will call the view to get the final result.

Can I call a stored procedure from a view in mysql?

No, you cannot. Views are typically read-only operations; and that behavior cannot be guaranteed if stored-procedures are invoked.

Expert · Answer

First, we will create a stored procedure in SQL Server Database. Second, enable the Data Access on the SQL Server instance. Third, create a view that uses the stored procedure. In the end, we will call the view to get the final result.

Expert · Answer

No, you cannot. Views are typically read-only operations; and that behavior cannot be guaranteed if stored-procedures are invoked.

Is it possible to call stored procedure in a view?

Can we call view in stored procedure in SQL Server?

Can I call a stored procedure from a view in mysql?

Related Questions