My database was running fine ,I made no changes to it and all of a sudden it started giving me errors in insert query such as
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '<'.
OR varchar is not recognized as build in function. This is what I get when I run a default query OR even when I create a new table
, it just not work , do I need to install something ? Please help!
IT WAS WORKING FINE A FEW DAYS BACK
I HAVE ALSO INSTALL NEW VERSION OF DATABASE MAY BE THAT IS THE ISSUE?
INSERT INTO [dbo].[userRegistration]
ERRORS start from this part.
What I have tried:
I have done a lot of research but all of the articles advise to fix the query, do note that this is a default MS sql server query I DID NOT WRITE THIS