insert data into two tables in SQL Server

create sp like

CREATE PROCEDURE [dbo].[User_InsertUser]
@Id INT
,@Name VARCHAR(100)
,@Behcode VARCHAR(100)
,@info VARCHAR(100) 
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO Users
(
Id,
Name,
Behcode,
info
)
VALUES (
@Id,
@Name,
@Behcode,
@info
)
INSERT INTO Main
(
Id,
Name,
Behcode
)
VALUES (
@Id,
@Name,
@Behcode
)
END