lancerxe
asked on
SINTAX ERROR IN SP
ASKER
IF (@Project = 'SmartCare')
Where is the END statement for WHILE loop
ASKER
error mesaage
Msg 156, Level 15, State 1, Procedure usp_QA_Defects_1_Business_ Area, Line 80
Incorrect syntax near the keyword 'IF'.
Msg 156, Level 15, State 1, Procedure usp_QA_Defects_1_Business_ Area, Line 110
Incorrect syntax near the keyword 'AND'.
Msg 156, Level 15, State 1, Procedure usp_QA_Defects_1_Business_
Incorrect syntax near the keyword 'IF'.
Msg 156, Level 15, State 1, Procedure usp_QA_Defects_1_Business_
Incorrect syntax near the keyword 'AND'.
Hi,
INSERT STATEMENT should be inside IF STATEMENT
Otherwise it is assuming that VALUES caluse but fount IF statement
INSERT STATEMENT should be inside IF STATEMENT
Otherwise it is assuming that VALUES caluse but fount IF statement
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i will try that. thanks rajvja.
Which line you are getting error. I guess, the syntax for identity column is Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY
If not, post the line