SQL Update Statement

SQL Update Statement

Hi friends, in this post we will learn about SQL Update Statement or you can say Update Query to update existing data in SQL server tables. SQL Update Statement are used to update data rows in table. SQL Update Query can always used with conditions only.

Earlier we had discussed about SQL Select StatementSQL Insert StatementDrop Table SQL ServerRename Table in SQL ServerCreate Table SQL ServerSchema In SQL ServerSQL Server OperatorsData Type in SQL Server and Drop-Delete SQL Server Database Using Management Studio or Query.

SQL Update Query:

----USE DATABASE IN WHICH WE WANT TO UPDATE TABLE----
USE Hightechnology
GO

----UPDATE DATA----
UPDATE STUDENT_INFORMATION SET PERMADDRESS='MUMBAI' WHERE ID=2

----SELECT RECORD FROM TABLE FOR CHECK----
SELECT * FROM STUDENT_INFORMATION
GO

SQL Update through Management Studio:

1. Open SQL Server Management Studio, and connect to SQL Server.

2. Expand Database name > Right click on table, from which you want to Update data and click on Edit Top 200 Rows.

3. It will open table in editable mode, now we can update data into columns. Once update is complete. Close the query window.

SQL Update Statement