create procedure temporay_table_test
as
begin
declare @frdate datetime
declare @cnt int
create table #tempx (idx int identity (1,1), frdate datetime)
set @cnt = 1
while @cnt < 5
begin
waitfor delay ‘00:00:01′ — 시간 delay
set @frdate = getdate()
set @cnt = @cnt + 1
insert into #tempx (frdate) values (@frdate)
end
select * from #tempx
end
if object_id (‘tempdb..#tempx’) is not null drop table #tempx
