There are four basic SQL Operations or SQL Statements.
SELECT - This statement selects data from database tables.
UPDATE - This statement updates existing data into database tables.
INSERT - This statement inserts new data into database tables.
DELETE - This statement deletes existing data from database tables.
If you want complete syntax for this four basic statement, please download FAQ (PDF) from SQL SERVER - Download FAQ Sheet - SQL Server in One Page
Reference : Pinal Dave (http://www.SQLAuthority.com)
pinaldave
How do I write an Update Statement for the following:
Databases are:
I and B. —–Both on the same server.
The tables are:
I.tblInstitution and
B.tblBData
The columns are:
B.tblBData.InstFK —-Needs update
B.tblBData.LeID
I.tblInstitution.InstPK
I.tblInstitution.LeID
B.tblBData.InstFK = I.tblInstitution.InstPK
Where B.tblBData.LeID = I.tblInstitution.LeID
Thank you.
@sue
This might work,
Use B
update tblBData
set tblBData.InstFK = A.InstPK from I..tblInstitution A
Where tblBData.LeID = A.LeID
You are using wrong four-part-name syntax.
Four-part-name is something like this,
servername.databasename.ownername.objectname
but you misunderstood this concept and replaced the last objectname by column name.
Hope this helps,
Imran.