ALTER PROCEDURE usp_AddOrder2
AS
BEGIN

	BEGIN TRY
		BEGIN TRANSACTION;
		INSERT INTO [dbo].[Orders]
				   ([CustomerGUID]
				   ,[EmployeeID]
					)
			OUTPUT INSERTED.$ROWGUID
			VALUES ( DEFAULT, DEFAULT ),
			( DEFAULT, DEFAULT ),
			( DEFAULT, DEFAULT )
		COMMIT TRANSACTION;
    END TRY
    BEGIN CATCH 

        -- Print error information.
		SELECT
			ERROR_NUMBER() AS ErrorNumber,
			ERROR_SEVERITY() AS ErrorSeverity,
			ERROR_STATE() as ErrorState,
			ERROR_PROCEDURE() as ErrorProcedure,
			ERROR_LINE() as ErrorLine,
			ERROR_MESSAGE() as ErrorMessage;
  
        IF XACT_STATE() <> 0
            ROLLBACK TRANSACTION;
	END CATCH ;
END ;
GO