NEW TECHNOLOGY AND APPLICATION

NEW TECHNOLOGY AND APPLICATION: 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 NU...

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...