0
SQL - Updating a table with fully qualified name?
Can I update a table using a fully qualified name? What if this involves using columns with equal names from different tables?
3 Réponses
+ 4
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
+ 4
Josue Amaral welcome
0
Awesome, DishaAhuja! Thanks!