Home Forums SQL Server 2005 SQL Server 2005 General Discussion Insert Error: Column name or number of supplied values does not match table definition. RE: Insert Error: Column name or number of supplied values does not match table definition.

  • February 28, 2010 at 4:12 pm

    #1126323

    HI Toby White

    Thanks for looking into it..............

    You are right the above query is not working even in SQL 2000 but I missed an Order by clause in query to mention

    If you add an order by clause in query it will start working in SQL 2000.

    It is very annoyin... it looks like one of SQL 2000 bugs or may be there is some server settings which allows this kind of behaviour

    I hope its Server settings otherwise I will have to go through each SP to locate and fix this for SQL 2005

    CREATE TABLE

    #Table1

    (

    Column1 int,

    Column2 varchar(255),

    Column3 int NULL,

    Column4 int NULL

    )

    INSERT INTO #Table1

    SELECT

    Table2.Column1,

    Table2.Column2,

    Table2.Column3

    From Table2

    order by column1