CODEWITHSUNDEEP
sql-server
user83450
user83450

Reputation: 471

How should I get stored procedure result set in sql server 2005?

I have a stored procedure that named globalsearch. the stored procedure return some results. the problem is how should I get results that is returned stored procedure in sql server 2005.thanks!

Upvotes: 0

Views: 520

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294297

If you're asking how to get the result of a procedure from another procedure, the only way is to capture it into a table insert. See this article on MSDN covering the subject in detail: Getting Creative with EXEC.

Upvotes: 1

Related Questions