Hi! I used below code it's not worked:
declare @id int,@d int,@i int
select @id = max(Id) from TblFirst
select @d = max(Id) from TblSecond
if @id = 0 and @d = 0
set @i = 1
if @id > @d
set @i = @id
else
set @i = @d
insert into TblFirst(Id, Name)values(@i, 'Firuz')