sql stored procedure

Question

1.00/5 (1 vote)

See more:

Hello

How to pass sql server table name as Stored procedure paramater

example :

SQL

 @TABLE_NAME NVARCHAR(100)

  SELECT * FROM @TABLE_NAME

END

Posted 21-Mar-13 5:25am

Daqdibi

Updated 2-Mar-16 23:49pm

Maciej Los

v2

Add a Solution

Comments

Richard C Bishop 21-Mar-13 11:26am

Find out how to pass a parameter to a stored procedure, then use what you want.

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)

José Amílcar Casimiro · Accepted Answer · 2013-03-21T05:45:00

Solution 1

Hi Daqdibi,

You will have to do something like this:

SQL

create procedure dbo.myProcedure
(
   @tablename nvarchar(100)
)
as
Declare
   @Stmt nvarchar(max)
begin

   Set @Stmt = 'SELECT * FROM ' + @tablename
   Exec (@Stmt) 

end

Good luck.

Posted 21-Mar-13 5:45am

José Amílcar Casimiro

Comments

Richard C Bishop 21-Mar-13 11:52am

I am sure you only mean to help, but sometimes we have to take a step back and analyze if what we are doing is actually helping or not. In this case, spoon feeding the OP the most basic info is only promoting the OP to not research and learn for themselves. Just a friendly comment to think about.

José Amílcar Casimiro 21-Mar-13 11:55am

Makes sense. Sometimes i think it is necessary to help beginners so they do not lose the will to continue.

Richard C Bishop 21-Mar-13 11:58am

I understand your position, I am pleased you are willing to help others get up and going.

José Amílcar Casimiro 21-Mar-13 12:06pm

It's always a difficult decision to choose what will be more accurate when trying to help a coder. It depends on the coder.
However the solution presented is for educational purposes only.
I hope he does not put this code in a production environment.

Daqdibi 21-Mar-13 12:46pm

I needed just signature.Thanks Jose .You helped me a lot. richcb despite adding so nosense ideas , help learners .Programmer is not academy learner to learn everything.There is not time to play .

Richard C Bishop 21-Mar-13 12:51pm

You thread did not follow any of the guidlines for posting here. The fact that you even asked this question shows us that you did not even do the most basic research to even try and find an answer. Also, since you got offended by just a basic statement shows your lack of humility and ability to accept criticism.

Maciej Los 21-Mar-13 12:32pm

Good answer, +5!

Daqdibi 21-Mar-13 12:43pm

I needed just signature.Thanks Jose .You helped me a lot. richcb despite adding so nosense ideas , help learners .Programmer is not academy learner to learn everything.There is not time to play .