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

3

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…

Continue Reading