Error after adding a new column in SQL SERVER

Question

i added a new column to a table using the follwing:

ALTER TABLE Parit
ADD test nvarchar(50)

when then i try to refer to the table it shows the colmun but i get a red dotted line under the column name sayin invaild column name

in the ssms you can press Ctrl+Shift+R to update the IntelliSense — Sergey, Oct 04 '22 at 07:42
thank you it works , but when i try to update i get the following : Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the nvarchar value 'test' to data type int. — avihus, Oct 04 '22 at 07:47
i am doing thw following : UPDATE Parit set [test_column] = RIGHT(Parit.[test_column],LEN(Parit.[test_column]-1)) — avihus, Oct 04 '22 at 07:49
You tried to run `LEN([test_column]-1)` instead of `LEN([test_column])-1` — Panagiotis Kanavos, Oct 05 '22 at 12:14

score 0 · Answer 1 · answered Oct 04 '22 at 07:45

0

This is not an error.

Just IntelliSense needs to be updated. You can update IntelliSense by pressing Ctrl + Shift + R

answered Oct 04 '22 at 07:45

Meyssam Toluie

it works , but now when i try to update i get the following: Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the nvarchar value 'test' to data type int. – avihus Oct 04 '22 at 07:47
What is the actual data type of the new column and your update command? – Meyssam Toluie Oct 04 '22 at 07:48
i am doing thw following : UPDATE Parit set [test_column] = RIGHT(Parit.[test_column],LEN(Parit.[test_column]-1)) – avihus Oct 04 '22 at 07:49
they are all nvarchar – avihus Oct 04 '22 at 07:49
UPDATE Parit set [test_column] = RIGHT(Parit.[test_column],LEN(Parit.[test_column])-1) – Meyssam Toluie Oct 04 '22 at 07:49
Try my last comment. -1 must be out of LEN function. – Meyssam Toluie Oct 04 '22 at 07:50

1 Answers1