September 17, 2013 at 12:42 am
Many of you may know this but I found below observation today and though of posting it:
I have creted One procedure test1 and created temp table in it. Executed another procedure test2 and fetch temp table created in
parent procedure test 1. it ran fine.
**********************************************************************************************
create procedure dbo.test2
as
begin
select * from #temptabletest
end
create procedure dbo.test1
as
begin
create table #temptabletest
(
col1 int
)
insert into #temptabletest values(1)
insert into #temptabletest values(2)
insert into #temptabletest values(3)
exec dbo.test2
end
Exec dbo.test1
September 17, 2013 at 3:25 am
Hi
Temporary tables are limited to the session. A local temporary table that is created in a stored procedure is dropped when the procedure ends. You execute proc test2 when test1 is still "alive".
Br.
Mike
September 17, 2013 at 4:55 pm
C Hrushi (9/17/2013)
Many of you may know this but I found below observation today and though of posting it:
Thank you for your thoughtfulness. This is actually a good subject that has many different aspects to it. For example, it could be used to pass 100,000 "parameters" to a stored procedure without using Table Valued Parameters, XML, or a whole gambit of other things. If you care to get your feet wet, do some research and write a short article about it. Submit the article to this site. Just as a thought for a "first timer", you might want to have a couple of people review your article before submitting it.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy