It's just an simple starting but still get that mistake what should I do? I have SQL Server 2019
SELECT *
FROM .CUSTOMER
WHERE CİTY='SAMSUN'
RESULT
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'WHERE'.
Completion time: 2022-06-10T01:07:22.2091262 03:00
CodePudding user response:
First the .CUSTOMER should just be CUSTOMER and second, your CITY has a funny I, it is CİTY.
Not sure what İ is? Looks like an I with a dot over it. If I do a find in my editor and put in an I it doesn't match.
CodePudding user response:
Ow sory i just try to do something different. I deleted that period but i still get that result. And if i try that column: SELECT * FROM CUSTOMER WHERE CUSTOMERNAME = 'Salih FAYDALI'
Still get that warning: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'WHERE'.
Completion time: 2022-06-10T01:19:55.3479563 03:00