Stored procedure

Thanks, satyapriya

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

Hi Eddie,



If this post helps you mark it as answer

Thanks

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(sid,sname,smarks,saddress,year) 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=@sname,smarks=@smarks,saddress=@saddress,year=@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