 create table northwind.dbo.t_30(
id int primary key check(id between 21 and 30),name varchar(10))
go
--分区视图
create view v_t
as
select * from tempdb.dbo.t_10
union all
select * from pubs.dbo.t_20
union all
select * from northwind.dbo.t_30
go
--插入数据
insert v_t select 1 ,''''aa''''
union all select 2 ,''''bb''''
union all select 11,''''cc''''
union all select 12,''''dd''''
union all select 21,''''ee''''
union all select 22,''''ff''''
--更新数据
<< 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] 下一页 |
