Insert Error: Column name or number of supplied values does not match table definition RSS

• • Reply
  

  Veera Venkat...

  Member

  11 Points

  83 Posts

  Insert Error: Column name or number of supplied values does not match table definition

  Jun 29, 2007 05:20 AM|LINK

  hi

  i am getting an error("Insert Error: Column name or number of supplied values does not match table definition")  in sql server 2000 while inserting values in temp table .  with this query.

   

   create table #TemptableXML 
    ( 
    
    ordNum varchar(20),
    offerseqd numeric, 
    Qty numeric
    
   
    )  
   
   
   INSERT INTO #TemptableXML 
       ( 
       ordNum, 
       offerseqd, 
       Qty 
       ) 
       SELECT  
       OrderNo, 
       OfferSequenceId, 
       Quantity 
       FROM   OPENXML (@idoc,'//OfferBO') 
       WITH 
       ( 
       OrderNo varchar(20) '//OrderNo', 
       OfferSequenceId numeric(9) 'OfferSequenceId', 
       Quantity numeric(6,2) 'Quantity' 
       ) 
       XMLOpOrderOfferDetails

   

   

   

  SQL Server 2000

• • Reply
  

  ps2goat

  Star

  10845 Points

  1977 Posts

  Re: Insert Error: Column name or number of supplied values does not match table definition

  Jun 29, 2007 02:44 PM|LINK

  Have you tried it without naming the xml table?

   

  INSERT INTO #TemptableXML
       (
         ordNum,
         offerseqd,
         Qty
       )
       SELECT
       OrderNo,
       OfferSequenceId,
       Quantity
       FROM   OPENXML (@idoc,'//OfferBO')
       WITH
       (
         OrderNo varchar(20) '//OrderNo',
         OfferSequenceId numeric(9) 'OfferSequenceId',
         Quantity numeric(6,2) 'Quantity'
       )

   

  ---------------------------------------
  MCP - Web Based Client Development .NET 2.0
  • Marked as answer by Bo Chen – MSFT on Jul 05, 2007 03:08 AM
• • Reply
  

  Bo Chen – MS...

  All-Star

  17706 Points

  1389 Posts

  Re: Insert Error: Column name or number of supplied values does not match table definition

  Jul 04, 2007 08:13 AM|LINK

  check the links below. they are all addressing on the same issue as you are encountering. BTW, please post your question to the right place next time,we have a designated sqlserver support forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1 ), i believe you can get much better help there. thanks.

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=5969

  http://www.mcse.ms/message1679124.html

  http://www.thescripts.com/forum/thread666155.html

  Hope my suggestion helps

   This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

  Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
  • Marked as answer by Bo Chen – MSFT on Jul 05, 2007 03:06 AM