Can you use a stored procedure in a query?

Question

You can't execute a stored procedure as part of another query. See if you can use a view of UDF to represent the same structure that the SP would return. Another option: execute the stored procedure first and use the results in your main query. 22 мар. 2013 г.

Can we use stored procedure in a query?

Stored procedures are typically executed with an EXEC statement. However, you can execute a stored procedure implicitly from within a SELECT statement, provided that the stored procedure returns a result set.

How can we call stored procedure in SQL query?

You can call an SQL stored procedure with the execute, open, or get statement; in each case, you use the #sql directive. A stored procedure is a set of instructions for a database, like a function in EGL.

How do you execute a procedure in a query?

In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases. Expand the database that you want, expand Programmability, and then expand Stored Procedures. Right-click the user-defined stored procedure that you want and select Execute Stored Procedure.

How do you query the results of a stored procedure?

The only way to work with the results of a stored procedure in T-SQL is to use the INSERT INTO ... EXEC syntax. That gives you the option of inserting into a temp table or a table variable and from there selecting the data you need.

Expert · Answer