clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601517 fiddles created (47950 in the last week).

create table myTable (i int)
 hidden batch(es)


create proc myInsert as begin insert into myTable (i) output inserted.i values (1),(2),(3) end
 hidden batch(es)


exec myInsert
i
1
2
3
 hidden batch(es)


create proc myDelete as begin create table #myTemp (i int) delete from myTable output deleted.* into #myTemp where i >= 2 select * from #myTemp end
 hidden batch(es)


exec myDelete
i
2
3
 hidden batch(es)