Why Join
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
Forumguidelines
Gcobani Mkontwana
1k
1.2k
87.9k
Incorrect syntax near end
Jan 23 2020 2:14 PM
Hi Team
I am tring to create store procedure, some how i am experience this issue 'Incorrect syntax near end'. Who can help me to solve this issue as i dont know how to fix it. Here my store procedure to perform this operation.
use eNtsaRegistrationDB;
CREATE
proc [dbo].[Usp_CheckUserRoles]
@UserId
int
as
begin
if((
select
COUNT
(WR.UserId)
FROM
webpages_UsersInRoles WR
inner
JOIN
webpages_Roles R
on
WR.RoleId = R.RoleId
where
WR.UserId =@UserId)> 0 )
begin
SELECT
1
end
else
begin
select
0
end
Reply
Answers (
1
)
Permission is deprecated only for compatibility
How to create dynamic sql based on optional values from temp