create temporay table store procedure data in sql server

create proc usp_getdate
as
select getdate()

declare @dtval varchar(20)
create table #temp(dtval datetime)
insert into #temp exec usp_getdate
select @dtval=dtval from #temp

select * from #temp

Post a Comment

0 Comments