473,387 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Error : partitioning column was not found ( Partitioning View)

Hi, Happy New Year.
I am trying to insert a query to a partitioned view but the error is :

Server: Msg 4436, Level 16, State 12, Line 1
UNION ALL view 'T' is not updatable because a partitioning column was not found.
Here is all my query statements :
Expand|Select|Wrap|Line Numbers
  1. create table t1
  2. (ID int primary key,
  3. Code int check(code between 1 and 15 ))
  4.  
  5. create table t2 
  6. (ID int primary key,
  7. Code int check(code between 16 and 30 ))
  8.  
  9. create view T as 
  10. select * from t1
  11. union all
  12. select * from t2
Then I am going to insert to View T by this query :
Expand|Select|Wrap|Line Numbers
  1. insert into T (ID,Code)
  2. values(1,2)
But I am facing the Error of partitioning column, With the check constraint I thought the partitioning column is defined.
Would you please help me?
Dec 31 '06 #1
0 1972

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Liam3 | last post by:
I'm having a problem with a table that accidently had a column added whose type is the same as the table. This is seriously creating a problem as I cannot delete the table and I really don't have...
0
by: Pai | last post by:
Hello there, every time I try to create a project using Visual Interdev 2003, I get the following error: The default web access mode for this project is set to file share, but the project...
7
by: Rajesh.............................. | last post by:
What is the impact of using a nullable column vs a not nullable column for partitioning a Union ALL View? I have a Union ALL View with ten underlying tables unioned based on different values for a...
1
by: Ivory056mt | last post by:
In SQL 2000, can you use a GUID as a partitioning column? The query select * from table where b_id between '00000000-0000-0000-0000-600000000000' and 'FFFFFFFF-FFFF-FFFF-FFFF-6FFFFFFFFFFF' ...
8
by: Sonny | last post by:
Hi, I don't know if I missed anything. I have 2 member tables and one partition view in SQL 2000 defined as following CREATE VIEW Server1.dbo.UTable AS SELECT * FROM Server1..pTable1...
1
by: gaholmes | last post by:
Hi, I am stumped and was hoping someone could help me out. Any help is appreciated. I have a view that looks sort of like this (but with a lot more entries of course) ...
1
by: razv210480 | last post by:
I have configured a logical standby database and need to update the ERROR column on DBA_LOGSTDBY_SKIP view to Y, to prevent SQL apply from stopping, for all owners who have STATEMENT_OPT='INTERNAL...
4
by: kavithadv | last post by:
hi Please help me i want to fix a column in grid view i used style for locking the column since i am setting the position as relative its not working properly i have given my code below ...
1
by: Bernard Cunanan | last post by:
Query failed with error: Unknown column 'bernard' in 'where clause' <?php session_start(); ob_start(); $host="localhost"; $user="bernard"; $pass="bernard"; $dbase="myproj";...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.