CODEWITHSUNDEEP
sql-server-2008
Tashi
Tashi

Reputation: 11

Invalid column name when inserting in SQL Server

Here is my query, but when I execute it, I get an error and the column does not exist in my table SLCCMN.

Please help - what's the problem?

INSERT INTO [Sales Ledger Transactions] (STMN, STSLMN, STInvoiceNum)
VALUES ('16989632', '1', '1')

Error:

Invalid column name 'SLCCMN'

Upvotes: 1

Views: 1070

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31775

Check the table for triggers, and see if there is an invalid column reference in the trigger code.

Then either remove the trigger, or remove the reference to the SLCCMN column in the trigger's code.

Upvotes: 4

Related Questions