TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jitendra Patel
NA
149
0
Insert Data in temparary Table Throw execute Sp inside sp
May 17 2011 10:18 AM
Hello
I have insert data into temperary table throw execute another stored procedure,
--exec SP_Test_Table 1
ALTER procedure SP_Test_Table
@ID bigint
as
create table #Temp(id int,name varchar(10),contactNo varchar(100),pincode varchar(100), city varchar(100))
select * into #temp from exec SP_Test_Table2 @ID
select * from #Temp
Reply
Answers (
1
)
How to assign a variable in select statement
Qurey related