SQL - Updating a table with fully qualified name?

Question

Can I update a table using a fully qualified name? What if this involves using columns with equal names from different tables?

Answer 1

Josue Amaral hi you can update by many ways.

you can use alias name for the more secure updation please ping me if have some query about any specific purpose so that I can do that query easily here.

syntax

UPDATE TableName SET Database1..TableName.ColumnName = 5, ColumnName4 = 4 FROM Database1..TableName WHERE Database1..TableName.Column7 = "the value you want to update with"

UPDATE Table1 SET Database1..Table1.Column1 = 5, Colum1 = 4 FROM Database1..Table2 WHERE Database1..TableName.Column2 =0

This way you can update the desired data by update query.

Like for an simple example

update sololearn set skills = 'C' where id = '25csr314';
So that I'd skill will be update with new one

Answer 2

Josue Amaral welcome

Answer 3

Awesome, DishaAhuja! Thanks!