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…
Continue Reading