how to pass the variable for the parameter instead of values?

Question

0.00/5 (No votes)

See more:

SQL-Server

@command=N'
use ' + @DBName + N'

this is the right way to pass the variable name for parameter?

Posted 22-Jan-14 20:19pm

venkivenkatesan

Add a Solution

Comments

Purna.N 23-Jan-14 2:24am

Can give me some clarity in the question ....
What you are doing using above variable..

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)

Christian Graus · Answer 1 · 2014-01-22T20:36:00

You can't do that. You can't change the DB you're using, based on a variable. IF you were doing a select, or an insert, then yes, you'd use the variable that way. However, you would not use quotes, or a + sign. I assume you're doing this in SQL, not in code.

Why would you set the DB you're using, based on a parameter ? Sounds like a broken design to me