Modify rows of a table with an expression : Update « Insert Delete Update « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Insert Delete Update
  3. Update

Modify rows of a table with an expression


1> CREATE TABLE project   (project_no   CHAR(4) NOT NULL,
2>                         project_name CHAR(15) NOT NULL,
3>                         budget FLOAT NULL)
4>
5> insert into project values ('p1', 'Search Engine',        120000.00)
6> insert into project values ('p2', 'Programming',          95000.00)
7> insert into project values ('p3', 'SQL',                  186500.00)
8>
9> select * from project
10> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)
project_no project_name    budget
---------- --------------- ------------------------
p1         Search Engine                     120000
p2         Programming                        95000
p3         SQL                               186500

(3 rows affected)
1>
2> -- Modify rows of a table with an expression.
3>
4> UPDATE project SET budget = budget*0.56
5> GO

(3 rows affected)
1> select * from project
2> GO
project_no project_name    budget
---------- --------------- ------------------------
p1         Search Engine                      67200
p2         Programming           53200.000000000007
p3         SQL                   104440.00000000001

(3 rows affected)
1> drop table project
2> GO
1>








Related examples in the same category

1.Updating Rows Based on Multiple Tables
2.An UPDATE statement can only modify data of a single table
3.Update statement and IN operator
4.Update a single column
5.Change more than one column by adding a comma and the additional column expression
6.Using an expression in our UPDATE statement
7.Update command with where condition
8.Update more than one columns in update clause
9.Update a single row
10.Use CASE in the UPDATE statement
11.Updating a Column Value
12.UPDATE with a Join
13.Reference a declared variable in an update statement
14.Math operator in update statement