Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a_r_satish
Yak Posting Veteran
84 Posts |
 Posted - 2006-02-10 : 07:56:38
|
| Hello All,For my application i am using the sp_depends procedure to get the table and the procedure details.I want the result to be moved to some temp table so that i can use the temp table for my future references. Is there any way to move the details to move the results fetched by the sp to a temp table??Thanks in advance..Regards,satish.r |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-10 : 08:09:03
|
| [code]create table #temp( obj_name varchar(100), obj_type varchar(100))insert into #temp exec sp_depends yourobjname[/code]----------------------------------'KH'everything that has a beginning has an end |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-10 : 09:12:05
|
| Note that, if you use temp table inseide the procedure, then it will lose its scope after the execution of the procedureMadhivananFailing to plan is Planning to fail |
|
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-02-11 : 00:23:46
|
| Thanks.Being a newbie, i face some problems with the basics.Regards,satish.r |
|
|
|
|
|
|
Result of Stored Procedure in a temp table