DECLARE @SQL VARCHAR(MAX);
SET @SQL ='if not exists (select top 1 * from ['+@tablename+'] where EmailID='+@EmailID+')
begin
insert into ['+@tablename+'](EmailID) values('+@EmailID+')
select result=2
end
else
select result=1
'
EXEC (@SQL);
This is the solution found.