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