TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
Guest User
Tech Writer
2.1k
481.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