1-) MSSQL RMOS - bir procedureden diğer procedureye table aktarma

create proc [dbo].[deneme2] as begin

declare @t table(col1 varchar(10), col2 float, col3 float, col4 float,col5 float)

insert @t values('a', 3,3,3,1)

insert @t values('b', 4,4,4,1)

select * from @t

end

--exec deneme2

create table #deneme5(col1 nvarchar(50),col2 int,col3 int, col4 int, col5 int)

insert into #deneme5

exec deneme2

select * from #deneme5

drop table #deneme5