About this question
As i am trying to run a simple UPDATE query as follows:
UPDATE [TILL].[dbo].[appParameters] SET [TILL].[dbo].[appParameters].[ParameterValue] = "1" WHERE [TILL].[dbo].[appParameters].[ParameterName] = "StaffTablesRefreshed"If the field [ParameterName] is the value "StaffTablesRefreshed", then set the value of [ParameterValue] to "1".
When executed, SQL Server throws an error:
Invalid column name 'StaffTablesRefreshed'
Both [ParameterName] and [ParameterValue] are nvarchar(255).
Am I missing something obvious here? Don’t know why getting an error SQL server invalid column name.
