insert into qualification(priority, name, salary)
values(2, 'Уборка1', 100) 
declare @id_qualification1 int
set @id_qualification1 = @@IDENTITY
--
insert into qualification(priority, name, salary)
values(3, 'Уборка2', 200) 

declare @id_qualification2 int
set @id_qualification2 = @@IDENTITY

-- добавим рабочего 
insert into worker(employment)
values(0)
declare @id_worker1 int
set @id_worker1 = @@IDENTITY

-- вывод таблицы квалификации до результата 
select*from qualification where ((id = @id_qualification1) and (id =@id_qualification2))
-- вывод таблицы рабочего 
select*from worker where id = @id_worker1