How to write a SQL Delete Update script with Row_number

Question

I want to delete and update my table row data on the basis of Rownumber How i will write Stored Procedure for this

dharmendr · Accepted Answer

Hi IkramshamsYou can write like the below query Refer the below article for writing in a single procedureSingle Stored Procedure for Select Insert Update Delete in SQL ServerSELECTSELECT ROWNUMBER OVER ORDER BY CustomerId AS RowNo  FROM CustomersUPDATEUPDATE Record SET CompanyName  39Wolski  Zajazd39 FROM SELECT  ROWNUMBER OVER ORDER BY CustomerId AS RowNo FROM CustomersRecord WHERE RecordRowNo  93DELETEDELETE Record FROM SELECT ROWNUMBER OVERORDER BY CustomerId AS RowNo FROM CustomersRecord WHERE RecordRowNo  93

How to write a SQL Delete Update script with Row_number

Company

Explore

Follow us

Contact Us