Post reply

How to avoid Error message: Column name or number of supplied values does not match table definition.

  • March 7, 2011 at 8:28 am

    #98072

    Is anybody know how to avoid error message to run following script without using "GO" between the "ALTER TABLE" and "INSERT INTO" which shows I comment out at below?

    CREATE TABLE #Temp

    (

    ID int,

    Names varchar(50),

    Description varchar(50)

    )

    INSERT INTO #Temp Values(1, 'Name1', 'Desc1')

    INSERT INTO #Temp Values(2, 'Name2', 'Desc2')

    ALTER TABLE #Temp Drop Column Description

    --GO

    INSERT INTO #Temp Values(1, 'Name1')

  • March 7, 2011 at 8:37 am

    #1295367

    Why would you want to do that? Genuine question, as there may be a better way of doing what you are trying to achieve if we have more information.

  • March 7, 2011 at 8:53 am

    #1295375

    Thanks for asking.

    Basically, what I want to do is create "a" big sql query script to cover some complex calculation. I knew that I can use some kind of break script into serveral pcs to avoid it. But just think about everything dynamic (I mean input), if you don't really know what is coming for the next run, and you want to split the incoming by using if condition or ..., then I just wonder if someone has better general solution for this.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply