insert view.sql

来自「本程序中即有讲义」· SQL 代码 · 共 40 行

create database mydb
go
use mydb
create table test
(id1 int,
name1 char(10),
tel char(10)
)
go
select * from test
go
insert test
values (1,'aaa','1234')

insert test
values (2,'bbb','2334')
go
select * from test
go
create view view1 as
select id1,name1 from test
go
insert view1 values (3,'cc')
insert view1 values (4,'dd')
go

select * from view1
go
select * from test
go
update view1
set name1='erw' where id1=4
go
select * from test
go
delete view1 where id1=3
go
select * from view1
go
select * from test