TSQL How to exec a stored procedure inside select query?

is it possible to execute a storep procedure inside select query ?

select e.Name, dbo.get_sth e.Id
from emp e

I get the error

Incorrect syntax near 'e.Id'

Answers


No. But you can execute a function inside a select statement. So recreate your Stored Procedure as a function and this should work.

It will be called for every row so be careful of performance if returning many rows.


Need Your Help

How to get Apache and PHP to talk

php apache

I have successfully installed both Apache and php on my computer, Now I want to know how

Converting HttpClient version 3 ProtocolSocketFactory use to version 4

apache httpclient

I have some code that uses HttpClient version 3. I would like to come up with a version 4 equivalent. I believe 4.0 but any version 4 would be helpful.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.