Thursday, 14 December 2017

MSSQL - Fix Error - Invalid column name

Msg 207, Level 16, State 1, Line 8
Invalid column name 'frank'.
Msg 207, Level 16, State 1, Line 8
Invalid column name 'sinatra'.



Watch solution on YouTube

To fix it replace
INSERT INTO [dbo].[Customers]
           ([FisrtName]
           ,[LastName])
     VALUES
           ("frank", "sinatra")
GO

with
INSERT INTO [dbo].[Customers]
           ([FisrtName]
           ,[LastName])
     VALUES
           ('frank', 'sinatra')
GO

No comments:

Post a Comment