Update Statement in SQL Server(TSQL)

With the Update Statement, we can update records in a table in the database. The most important thing to note when running this command is to specify the Where condition correctly. If we run the Update command without specifying the condition, all the records in the table are updated.

First, we are creating a table and inserting some data into it for using in our test:

Then, we update records whose value is ‘Faruk Erdem’ in the name column with the help of the script below:

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *