temp table in one sp,can i use that temp table in another sp

Question

I am using one temp table in one stored proc,Can i use same temp table in other stored proc?

---

Naresh

Answer 1

Yes..

Only  if temp table is created in first sp and 2nd sp is called with in 1st sp.. e.g bellow

create proc sp1 as

	create table #t(c char(5))
	insert into #t(c) values('a'),('b')
	exec sp2
	

create proc sp2 as
	select * from #t

exec sp1

VT

---

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

Read Erland's article http://www.sommarskog.se/share_data.html

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/