Interest in //Web //Win //Mobile //Database & //Life

2

SQL Error The multi-part identifier could not be bound.

I was trying to update data from one table of a database to
another table of another database.

The following TSQL makes sense about what I am talking

UPDATE db1.dbo.table1
SET db1.dbo.table1.data = db2.dbo.table2.data
WHERE db1.dbo.table1.ID = db2.dbo.table2.data.ID

but I was getting a error like The multi-part identifier could not be bound This can be solved byusing aliasing feature of tsql, so I changed my query like this and that solves my problem with
The multi-part identifier could not be bound

UPDATE t1 SET t1.data = t2.data FROM db1.dbo.table1 t1 INNER JOIN db1.dbo.table2 t2 ON t1.ID = t2.ID

Md Shiefuzzaman • April 18, 2014


Previous Post

Next Post

Comments

  1. binance Registro March 26, 2024 - 11:01 pm Reply

    Thanks for sharing. I read many of your blog posts, cool, your blog is very good.

  2. binance sign up bonus March 28, 2024 - 6:01 am Reply

    I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

Leave a Reply

Your email address will not be published / Required fields are marked *