There are four basic SQL Operations or SQL Statements. SELECT, UPDATE, INSERT and DELETE are the four basic 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
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
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….