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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Glyn Walters (glyn_walters_at_hotmail.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 03:31:47 -0700

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: Inserting into partion view - values were not supplied for all columns
    ... Wayne Snyder, MCDBA, SQL Server MVP ... "Glyn Walters" wrote in message ... > When I try to insert into a partition view with specified ... If I specify all the columns ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot mount old drive with LVM partition - help!
    ... When it got to hdb2, same crap, need to specify the file system type as ... I need to come up with some kind of linux disk ... recovery tools to try and get that second partition restored. ... It finds both drives. ...
    (alt.os.linux)
  • Re: HD problem
    ... specify which one to check? ... partition on the hard disk. ... It only has one partition. ... marginally better than "chkdsk /r" and some not at all. ...
    (microsoft.public.windowsxp.general)
  • Re: Patricks Test9 suspend code.
    ... like a resume partition would actually be more robust in that case. ... The objection's largely to having it hardwired into the kernel, ... specify resume isn't noticeably worse... ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Patricks Test9 suspend code.
    ... why do I have to specify which one to resume from? ... How is kernel expected to find out partition which it ... When do you have a heart between your knees? ... To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/ ...
    (Linux-Kernel)