Please explain your requirement in more details if possible share your HTML and Code.

I want to write a query in which data will be updated/deleted on the basis of row number.e.g. if my row number is 0 then first data which is in the table will be updated/deleted. For this, i want to write a stored procedure. How i will do it, please suggest me. 

Hi Ikramshams,

You can write like the below query. Refer the below article for writing in a single procedure.

Single Stored Procedure for Select Insert Update Delete in SQL Server

--SELECT
SELECT ROW_NUMBER() OVER (ORDER BY CustomerId) AS RowNo, * FROM Customers

--UPDATE
UPDATE Record SET CompanyName = 'Wolski  Zajazd' 
FROM (SELECT  ROW_NUMBER() OVER (ORDER BY CustomerId) AS RowNo,* FROM Customers)Record 
WHERE Record.RowNo = 93

--DELETE
DELETE Record FROM (SELECT ROW_NUMBER() OVER(ORDER BY CustomerId) AS RowNo,* FROM Customers)Record 
WHERE Record.RowNo = 93