Stored Procedure CURD Operation

Table Creation:
 -->CREATE TABLE User
 (  
  Id INT primary key NOT NULL,
  Name VARCHAR(50) NOT NULL,
  Email_id VARCHAR(50)NOT NUL
  ); 


1.Table To Insert The data

CREATE PROCEDURE [dbo].[InsertUser]
(
  @ID int,
 @Name varchar(50),
 @Email_id varchar(50)
)
AS
Begin
insert into User(Id,Name,Email_id)values(@Id,@Name,@Email_id)
END

2.Table To Delete The data

CREATE PROCEDURE [dbo].[delete_all]
(@ID INT)
AS
BEGIN
      delete from   User where ID = @ID
END

3.Table To Select The data

ALTER PROCEDURE [dbo].[select_all]
AS
BEGIN

SELECT *
FROM [dbo].[User]
END 

4.Table To Select By Id The data

ALTER PROCEDURE [dbo].[SelectById](@ID INT)
AS
BEGIN
      SELECT * FROM User WHERE ID = @ID
END

5.Table To Update Id The data

ALTER PROCEDURE [dbo].[update_all]
(@ID INT,@name varchar(50))
AS
BEGIN
      UPDATE  Userset ID = @ID,name=@name
END
5. Sub Queries to get the data