Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
anil john
2k
156
197.1k
Incorrect Yntax near AS
Nov 9 2012 4:46 AM
Plz help me to rectify the error:
Error: Incorrect syntax near the keyword 'As'.
Code:
declare @flag as int;
SET @flag='1';
SELECT Ci.iInstNumber AS InstNo,Ci.dInstDate AS InstDate, CASE WHEN (@flag='1')THEN SUM(Ci.fInstAmount+Ci.fShareProfit) ELSE Ci.fInstAmount As InstAmount END
Reply
Answers (
1
)
is there a way to prevent drop or truncate a specific table by admin , in sql server .
Incorrect syntax near the keyword As