Invalid column name??

Question

Given the following excerpt:
CREATE TABLE dbo.PlanOfCareLimitationTypes
( iPlanOfCareLimitationTypeID INT IDENTITY(1,1) NOT NULL,
sPlanOfCareLimitationCategory CHAR(6) NOT NULL,
sPlanOfCareLimitation VARCHAR(MAX) NOT NULL,
dtDateAdded DATETIME NOT NULL,
dtPurgeDate DATETIME NOT NULL,
dtDateUpdated DATETIME NULL,
dtDateDeleted DATETIME NULL,
chkIsTestRecord CHAR(1) NOT NULL,
chkIsInactive CHAR(1) NOT NULL
PRIMARY KEY CLUSTERED (iPlanOfCareLimitationTypeID ASC));

INSERT INTO dbo.PlanOfCareLimitationTypes
(sPlanOfCareLimitationCategory <= Why is this considered an “Invalid column?!?”
, sPlanOfCareLimitation
, dtDateAdded
, dtPurgeDate
, chkIsTestRecord
, chkIsInactive) VALUES
('18A'
,'Amputation'
, GETDATE()
, DATEADD(YEAR,7,GETDATE())
, 'N'
, 'N');

Answer 1

I suspect that there is a drop table in front of your table creation. Sometimes a prompt does not mean there is a problem. You can select the code and execute it all. If this is not the problem, refresh the cache and restart the client, copying the existing code to the new window.

Bert Zhou