Can we create insert and show the record from the table in single stored procedure

yes, we can

create proc sp_test
As
Begin
BEGIN TRANSACTION
insert into Test values(121,'latest','test',0)
COMMIT TRANSACTION

select * from Test
End