alter proc SetPermission @Kar_ID int,@CodeAmaliat int,@IsAllowed bit as begin if not exists(select isallowed from mahdoodiat where Amaliat_ID =@codeamaliat and Kar_ID =@Kar_ID) insert into mahdoodiat (Amaliat_ID,Kar_ID,isallowed)values(@codeamaliat,@Kar_ID,@isallowed) else update mahdoodiat set isallowed=@isallowed where Amaliat_ID =@codeamaliat and Kar_ID =@Kar_ID end