create proc add_organisation
@name_organisation varchar(100),
@faculty varchar(60),
@street varchar(30),
@street_number varchar(4),
@post_code varchar(5),
@country varchar(50),
@email varchar(50),
@telephone varchar(20),
@states varchar(10)
as
begin
    insert into organisation.organisation(name_organisation,faculty,street,street_number,post_code,country,email,telephone,states)
    values(@name_organisation,@faculty,@street,@street_number,@post_code,@country,@email,@telephone,@states)
END
EXEC add_organisation 'MIOP','Nature organisation','koCI','56','65490','Czech republic','[email protected] ','123456','EU'
go
create proc finance
@id_finance int,
@id_project int,
@tempus_grant int,
@total_co_financing int
as
begin
    insert into tempus.project_finance(id_finance,id_project,tempus_grant,total_co_financing)
    values(@id_finance,@id_project,@tempus_grant,@total_co_financing)
end
exec finance 1,1,12000,12000
tady máš procedury