The easiest way is to write a stored procedure which does the job - it starts a transaction, does the inserts (or updates, or deletes) and commits if it all works.
CREATE PROCEDURE sp_InsertMultiple
(
@Text1 varchar(255),
@Text2 varchar(255)
)
AS
BEGIN
BEGIN TRAN
INSERT INTO Table1 (Column1) VALUES (@Text1)
INSERT INTO Table2 (Column2) VALUES (@Text2)
COMMIT TRAN
END