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
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
0 Comments
if you have any doubts , please let me know