SQL Server Anonymous Block

 set nocount off;

declare @row as bigint;

declare @qty as int;

declare @yr as int;

set @qty=100;

set @yr=2017;

begin

delete from sample_table

insert into dx_rowcounter(modulename,rowcountt) values(concat(@yr,'_',@qty),@@rowcount)

end