can stored procedure return table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL-Server

Dear sir

Can store procedure return table

please explain with example

Posted 18-Nov-11 0:53am

mayur csharp G

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

deepakdynamite · Answer 1 · 2011-11-18T01:03:00

Solution 1

Hello

Check this out

http://stackoverflow.com/questions/1443663/how-to-return-temporary-table-from-stored-procedure[^]

http://odetocode.com/articles/365.aspx[^]

Posted 18-Nov-11 1:03am

deepakdynamite

Pandya Anil · Answer 2 · 2011-11-18T01:05:00

No SPs can not return table.

to 'Return' is different and 'Result Set' is different, whatever the values are returned from a select query inside the SP is not return value.

SP can have only one value as return type, it can not be table.

but UDF's can return defined/undefined tables.

thats why we can not use SP inside our select statement but we can use functions (UDFs) in it.

read more details at the given link.

http://geekswithblogs.net/NewThingsILearned/archive/2008/09/17/get-return-value-from-stored-procedure.aspx[^]

Om Prakash Pant · Answer 3 · 2011-11-18T01:08:00

Solution 3

yes, it can.

simple example is:

SQL

CREATE PROCEDURE Test_Proc
AS
BEGIN
 SELECT column_1, column_2 From table_name
END
GO

Above SP will return data from table_name

also check the following article on data returned by Stored procedure:

http://www.sqlteam.com/article/stored-procedures-returning-data[^]

Posted 18-Nov-11 1:08am

Om Prakash Pant

Comments

stixoffire 14-Dec-16 16:58pm

No it can't try using the result set in a secondary SQL statement - so call the stored procedure and then try to use those results in the same SQL Statement - using only SQL. No C#, VB, PHP, etc.. you will find it can not.