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 (https://blog.sqlauthority.com)
9 Comments. Leave new
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.
Hi Pinal,
I think there should be some awards who are answering the comments/questions of your articles.
gr8 going…..
@Vijaya
Awards? Imran, a big contributor, has his name bolded on the side bar. Pinal recognizes frequent contributors.
Hi Pinal,
i want to disable the stored procedure. Please tell me any way to disable.
What did you mean by disabling a procedure?
Hi ,
can MS Sql data migrate to Oracle DB?
also how to create Database backup using script ?
1 Yes. Use Import/Export wizard
2 Read about Backup command in SQL Server help file
ok thanks….