Get selective columns from a Stored Procedure

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

Dear All,

Is there a way through which i can get selective columns returned by a SP.

e.g.

SQL

create procedure sample_sp
as
begin
    select 1 col1, 2 col2, 3 col3
end

Now when i execute it in the backend, i want only col2 and col3
EXEC sample_sp

Is this possible by any means ????
I can not use function instead of SP.

Regards,
Gopal

Posted 31-Jan-13 20:44pm

gopalgupta

Add a Solution

Comments

Zoltán Zörgő 1-Feb-13 3:01am

What do you want exactly? Please improve your question, since how I have understood, it is the most basic of all tasks - but I suppose you wouldn't ask in that case. So might happen that I have not understood you. What do you mean by "selective columns"?

1 solution

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)

Santhosh Kumar Jayaraman · Answer 1 · 2013-01-31T21:22:00

Solution 1

Just make changes in the sp

SQL

create procedure sample_sp
as
begin
    select  2 col2, 3 col3
end

Posted 31-Jan-13 21:22pm

Santhosh Kumar Jayaraman

Comments

gopalgupta 1-Feb-13 4:20am

cant do this. my sp returns 10 columns and its been used at several places. i store the output of this sp by making a temp table and then insert the outout of this sp into that table. the problem is everytime i increase the number of columns returned by the sp, i have to make changes at all other places where this sp is referred

Santhosh Kumar Jayaraman 1-Feb-13 4:25am

it doesnt matter right? Wherever you are going to bind this datatable to a control, just filter only columns2 and columns3.If its a gridview, just bind the columns to those 2 columns

gopalgupta 1-Feb-13 6:33am

i m not using the output in the front end. it is completely back end related.