store procedure for update and delete query

Hi Faiza Saher,

For Update

 

Create PROCEDURE [dbo].[SpUpdate]  

@ID int,

@R_ID int,

@S_Name varchar(50),

@Phone_No numeric,

@Email varchar(50),

@S_Subject varchar(50),

@Marks numeric 

AS

Begin

UPDATE <TableName>

   SET R_ID = @R_ID,  

      S_Name=@S_Name,

      Phone_No=@Phone_No,

      Email=@Email,

      S_Subject=@S_Subject

      Marks=@Marks

 WHERE ID= @ID

End

For Delete

Create PROCEDURE [dbo].[SpDelete]  

@ID int,

AS

Begin

DELETE FROM <TableName>

 WHERE ID= @ID

End

Delete query delete the entire tuple/row. You can specify the the primary key or any other unique value using set of column or single column. ex:-
Delete from Employee where empID = 10;
It will delete entire row.

Update can be specific to column or set of column.
Syntax is
Update Table_Name Set col1 = "New Value",col2.....
Where some_condition.