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?
USE [CMS]
GO
INSERT INTO [dbo].[userRegistration]
([userName]
,[userEmail]
,[userPassword]
,[userDesignation]
,[userPhone])
VALUES
ERRORS start from this part.
(<userName, varchar(50),>
,<userEmail, varchar(50),>
,<userPassword, varchar(50),>
,<userDesignation, varchar(50),>
,<userPhone, varchar(50),>)
GO
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