Re: Inserting into partion view - values were not supplied for all columns

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 06:55:00 -0400

Check the column property ( null or not null)... That should be the
requirement... I don't think PVs have any additional requirements regarding
the columns except that the partitioning column is required. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Glyn Walters" <glyn_walters@hotmail.com> wrote in message
news:11e7401c44243$7b51d8a0$a001280a@phx.gbl...
> Hi.
>
> When I try to insert into a partition view with specified
> columns and values I get the error "values were not
> supplied for all columns". If I specify all the columns
> in the insert statement then the insert is ok. The first
> insert statement would be ok for any of the base tables.
> Is it therefore a limitiation of the partition view that
> all columns have to be specified? I hope not because it
> means all stored procedures will have to be updated
> alongside future view changes.
>
> Thanks for any advice on this
> Glyn

Relevant Pages

  • Re: SQL 2005 hardware recommendations
    ... I see that a striped set of mirrored pairs is preferable to a mirrored ... Nevertheless, Andrew, perhaps ... to have the boot partition separate from the data partition(and ... partitions and sizes for the installation of SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 hardware recommendations
    ... Since they would all be on a single array and there is no performance benefit I would make the array one big partition so there is no chance you will run out of space in each individual partition. ... If I opted for purchasing six 36 GB drives, I could use four to make a "RAID ... partitions and sizes for the installation of SQL Server 2005 ... backend mdb file to SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Question Folder Structure Best Practices
    ... there an alternative by using the D partition for Sql Server, Sharepoint? ... then you can install it better on ...
    (microsoft.public.windows.server.general)
  • Re: ROLAP + realtime
    ... > Because of the detailed prerequisites for using a Real-Time ROLAP ... > partition with aggregations, I've typically used Real-Time ROLAP with no ... > aggregations (which doesn't require the creation of indexed views in SQL ... > requirements for creating indexed views on SQL Server 2000, ...
    (microsoft.public.sqlserver.olap)
  • SQL Server 2005 Express as a Data Mart environment
    ... The data workbook has 36 sheets which represent a utility meter with 60-170k rows each with 3.5mil rows total. ... In converting from the data workbook to SQL server for interval storage it appears from my reading of 'The Data Warehouse Toolkit' from Kimball Group that a Data Mart is established using SSAS which I don't anticipate having access to until a couple months after the 6 month evaluation period of the SQL Server 2005 Enterprise evaluation has expired. ... 2)Multiple IntervalData fact tables where meters were distributed evenly over multiple tables in seperate partitions with a single meter occupying each partition. ... 15MinuteInterval TinyInt ...
    (microsoft.public.sqlserver.datawarehouse)