Error message when entering data into SQL Server database

1124240 pts.
Tags:
SQL Server
SQL Server database
For the past few days, I've been trying to enter my data into my SQL Server database but I keep getting this error: Invalid column name. Is there any reason why I'm getting this error?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Most likely you have a typo in your SQL statement. Verify the column names you have specified in your SQL statement are in the table in the schema that you are trying modify

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • edwinjhoffer
    If the column already exist then you need to press Ctrl+Shift+R to refresh the local cache.
    3,740 pointsBadges:
    report
  • ToddN2000
    Self explanatory. You are trying to insert into a column name that does not match. Verify the column names are correctly spelled. You can check names using SQL Server Management Studio.
    Navigate to your database, select the table in question. Click the plus to expand the options, click the plus next to Columns and you can verify the names.
    125,805 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: