create table x1(i int, c int check(c<10), primary key(i,c))

create table x2(i int, c int check(c>20), primary key(i,c))

create table x3(i int, c int 
check( (c between 11 and 18) and (c between 12 and 19) ), primary key(i,c))
go

create view x as
select i,c from x1
union all
select i,c from x2
union all
select i,c from x3
go
insert x(i,c) select 342,2345632
go

select * from x
go
drop table x1,x2,x3
go
drop view x



Server: Msg 4436, Level 16, State 12, Line 1
UNION ALL view 'x' is not updatable because a partitioning column was not found.
i           c           
----------- ----------- 

(0 row(s) affected)

quote:

---

BOL:
Each base table has a partitioning column whose key values are enforced by CHECK constraints. The key ranges of the CHECK constraints in each table do not overlap with the ranges of any other table. Any given value of the partitioning column must map to only one table. The CHECK constraints can only use these operators: BETWEEN, AND, OR, <, <=, >, >=, =.

---

create table x1(i int, c int check(c<10), primary key(i,c))

create table x2(i int, c int check(c>20), primary key(i,c))

create table x3(i int, c int 
check( c between 11 and 19 OR c between 12 and 20), primary key(i,c))
go

create view x as
select i,c from x1
union all
select i,c from x2
union all
select i,c from x3
go
insert x(i,c) select 342,2345632
go

select * from x
go
drop table x1,x2,x3
go
drop view x



(1 row(s) affected)

i           c           
----------- ----------- 
342         2345632

(1 row(s) affected)