Unable to update a table using sql query in sql server

Question

I use sql server 2014.

I have a table in my ManuDB database called (waqf).

I am trying to update the table but not allowed and a message (invalid object name waqf) appears.

I don't know what is the reason although I have a table called waqf.

Your query currently is in the master database (see the dropdown just above the Object Explorer) - and there's no table of that name in the master database! — marc_s
– marc_s, Commented May 2, 2014 at 15:32

M.Ali · Accepted Answer · 2014-05-02 15:34:48Z

3

Because you are executing the statement in Master Database as shown in the snip shot.

enter image description here

select the correct database from drop down list shown in picture or execute the following statement.

USE ManuDB 
GO

UPDATE ......

answered May 2, 2014 at 15:34

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

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

5 Comments

M.Ali Over a year ago

You'er welcome :) and dont worry its not only the new ones who make this mistake, people working with sql server for years still make this mistake but we know how to fix it.

Aisha Ahmed Ahmed Over a year ago

ok can I ask a question ~~ I conected my dB with a website using visuall studio but I have a problem can I ask ?

M.Ali Over a year ago

Yes sure go ahead if I can help I will

Aisha Ahmed Ahmed Over a year ago

ok In my my waqf table I have a column for images I only inseted the image link E.g w_img=N'Images/1.jpg' in the website I connected evry thing but when I run the website all the table appears except the image I dont know why the picture show the website and the image should appear inthe left majaless.com/up/get-5-2014-8payeas0.jpg

Aisha Ahmed Ahmed Over a year ago

stackoverflow.com/questions/23433003/…

Latheesan · Accepted Answer · 2014-05-02 15:32:18Z

1

From the drop down list of database; set it to ManuDB.

At the moment, it's pointing to Master which doesn't have your table.

answered May 2, 2014 at 15:32

Latheesan

24.1k34 gold badges113 silver badges212 bronze badges

Comments

mordack550 · Accepted Answer · 2014-05-02 15:34:00Z

1

Type USE <yourdatabasename> before your update statement

answered May 2, 2014 at 15:34

mordack550

5014 silver badges14 bronze badges

Collectives™ on Stack Overflow

Unable to update a table using sql query in sql server

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related