Mega Code Archive

 

Categories / MSSQL / Insert Delete 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>