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>