SQL command returns invalid object name database.table

Question

I run this code:

                    SqlConnection polaczenie;
                    polaczenie = new SqlConnection(dane_polaczenia);
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = polaczenie;
                    polaczenie.Open();
                    cmd.CommandText = @"SELECT * FROM test.test";
                    cmd.ExecuteNonQuery();

After executing I got exception Invalid object name 'test.test'.

Database and table values are correct.

How to specify database.table in CommandText correctly?

RichardTheKiwi · Accepted Answer · 2012-11-07 18:51:14Z

1

                cmd.CommandText = @"SELECT * FROM test.dbo.test";

or

                cmd.CommandText = @"SELECT * FROM test..test";

answered Nov 7, 2012 at 18:51

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

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

Collectives™ on Stack Overflow

SQL command returns invalid object name database.table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related