store procedure for update and delete query

Question

for the following fields how would i write the update and delete query ID int R_ID int S_Name varchar(50) Phone_No numeric Email varchar(50) S_Subject varchar(50) Marks numeric

N Vinodh · Answer

Do you have unique ID for any of the column......

N Vinodh · Answer

Do you have unique ID for any of the column......

Manish Kumar Choudhary · Answer

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

Sushil Gupta · Answer

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 Valuecol2..... Where some_condition.