Home Forums SQL Server 2012 SQL 2012 - General SQL Insert Into question RE: SQL Insert Into question

  • August 28, 2015 at 1:03 pm

    #1823143

    you altered the table and added a new column [date1]

    the table [Metrics].[dbo].[x64_Restore_Metrics_All_Temp] now has four columns, but your insert has only three.

    if you do insert into table without a column list, your query has to match teh number of columns(that are not identity and not calculated)

    just change to have the right columns you want to inser:

    Insert Into [Metrics].[dbo].[x64_Restore_Metrics_All_Temp] ([date],[bytes],[Whos])

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!