User defined table in Sql Server

Question

Can I return integer value after an insert using Stored Procedure with used in user defined type in SQL Server?

 

if successful return 1

if error return 0

if Yes ..

 

How?

 

Please explain with one example.

 

I have created this user type and stored procedure and used in asp.net, it is inserted.

 

But my question is can I return integer value after successful.

CREATE TYPE InsertEmployee AS TABLE(
[emp_id] [int] NOT NULL,
[emp_name][varchar(100)]
)
GO
CREATE PROCEDURE sp_InsertEmployee
(
@DataTableDetails InsertEmployee READONLY
)
AS
BEGIN
INSERT INTO tbl_employee
SELECT emp_id, emp_name
FROM @DataTableDetails
END