CREATE PROCEDURE iddaneshg @c as nvarchar(30) AS declare @m int select @m=max(chek) from danesh where idd like @c if @m=null select 1 as shomaredanesh else select @m+1 as shomaredanesh GO