if the records have been added to a table, whether the operation was successful or not, we had no way of immediately finding out (we would have to open the table). One way you can get this information is to store the inserted records in another table. To support this, Transact-SQL provides the OUTPUT operator
insert into videos output inserted.* values('Shadow','skkjjjk',2013),
('mirchi','shiva',2012);
select * from videos