sql server - T-SQL : UNION ALL view not updatable because a partitioning column was not found -
how can insert in view date constraints? here tables resulted after clicking on script create table : table 1 : create table [dbo].[tbl_zaua_1_17]( [id] [int] not null, [date] [datetime] null, constraint [pk_tbl_zaua_1_17] primary key clustered ( [id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] go set ansi_padding off go alter table [dbo].[tbl_zaua_1_17] check add constraint [ck_tbl_zaua_1_17] check (([date]<'2014-01-18 00:00:00.000' , [date]>'2014-01-16 00:00:00.000')) go alter table [dbo].[tbl_zaua_1_17] check constraint [ck_tbl_zaua_1_17] go` table 2 : create table [dbo].[tbl_zaua_1_11]( [id] [int] not null, [date] [datetime] null, constraint [pk_tbl_zaua_1_11] primary key clustered ( [id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_pag...