How to pass $(DB) parameter to SqlCommand?

Question

I have the following query:

use [$(DB)]
select * from users

but I cannot pass the parameter trough SqlCommand. It works only from the command line tool. It says that $DB database does not exist, so the parameter is not passed.

            SqlCommand cmd = new SqlCommand(query, connection);
            cmd.Parameters.AddWithValue("DB", "theDatabase");
            cmd.ExecuteNonQuery();

Any ideas?

These are migration scripts which are hundreds of hundreds. MSSQLSERVER 2005 and 2008 — mynkow
– mynkow, Commented Feb 21, 2012 at 15:59
mynkow if these are migration scripts the you should be able to determine what DB each script is working off of.. also what ever script or batch process that is doing it now.. as a temporary work around .. could you now create a console app that spawns or Creates that Process which calls the code at hand use [$DB] select * from users..? — MethodMan
– MethodMan, Commented Feb 21, 2012 at 16:05
At the moment all scripts are executed from very old application which uses sql command line tool. We are trying to refactor that application. Yes, I can. — mynkow
– mynkow, Commented Feb 21, 2012 at 18:39

Иван Вълчев · Accepted Answer · 2012-02-22 07:28:03Z

2

SQLCMD has its own commands, which it parses separately from SQL/T-SQL statements. These commands are not understood by SQL Server or other scripting tools like SSMS

http://sqlblog.com/blogs/michael_coles/archive/2010/01/10/parent-child-build-scripts-with-sqlcmd.aspx

answered Feb 22, 2012 at 7:28

Иван Вълчев

1311 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Void · Accepted Answer · 2012-02-21 16:10:07Z

0

The only way I can think of doing that is ti use exec to like this:

exec ('use ['+ @db + ']; SELECT * FROM someTable');

I'm not sure if this will help you but...

answered Feb 21, 2012 at 16:10

Void

2651 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to pass $(DB) parameter to SqlCommand?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related