Try somthing like this
CREATE PROCEDURE sp_insert_userdetailss
@name nvarchar(100),
@email nvarchar(100),
@phon_no nvarchar(100),
@photo nvarchar(100)
As
BEGIN
IF EXISTS(SELECT name,email,[phono no] FROM user_details WHERE email=@email)
UPDATE user_details
SET name=@name,email=@email,[phono no]=@phon_no,photo=@photo;
ELSE
INSERT INTO user_details(name,email,[phono no],photo)
values (@name,@email,@phon_no,@photo)
SELECT MAX(user_details.id)
FROM user_details
INNER JOIN city ON user_details.city_id=city.id
INNER JOIN area ON user_details.area_id=area.id
INNER JOIN usertype ON user_details.type_id=usertype.id;
END;