Stored procedure

Question

Hi we create a table in sql server database. how we can create a stored procedure for insert and update records in the table ?

Eddie Jack · Answer

Thanks satyapriya But I Want to insert and update in a singe table with single stored procedure.

Satyapriya Nayak · Answer

Hi Eddie If this post helps you mark it as answer Thanks

Satyapriya Nayak · Answer

Hi Eddie Please see the below code -------------------To display records from database------------ CREATE PROCEDURE display AS select * from student ------------------- To insert records from database------------ CREATE PROCEDURE insert1 (@sid varchar(50)@sname varchar(50)@smarks int@saddress varchar (50)@year varchar(50)) AS insert student(sidsnamesmarkssaddressyear) values (@sid@sname@smarks@saddress@year) ------------------- To update records from database------------ CREATE PROCEDURE update1 (@sid varchar(50)@sname varchar(50)@smarks int@saddress varchar (50)@year varchar(50)) AS update student set sname=@snamesmarks=@smarkssaddress=@saddressyear=@year where sid=@sid ------------------- To delete records from database------------ CREATE PROCEDURE delete1 (@sid varchar(50)) AS delete from student where sid=@sid Thanks If this post helps you mark it as answer