SQL Server stored procedure that would enforce atomicity?
BEGIN TRY
BEGIN TRANSACTION

INSERT INTO tEmpl  (lastName)  VALUES('Smith'),('Jones'),('Smitty'),('Smithson') 

COMMIT TRANSACTION
PRINT 'Transaction committed successfully'

END TRY

BEGIN CATCH 
ROLLBACK
PRINT 'Transaction rolled back'

END CATCH