Find all row and execute code for each row in sql

Question

I have function like this in asp.net :

DataTable dt = dal.ExecuteDataTable(CommandType.Text, "SELECT KID FROM Chart", new SqlParameter[] { });

for (int i = 0; i < dt.Rows.Count; i++)
{
    Update(Convert.ToInt64(dt.Rows[i]["KID"]));
}

What is the equivalent of this code in SQl? Can we execute both of select and update in one procedure ?

What are you trying to achieve here? What is the problem that you are attempting to solve? — user5151179, Dec 01 '15 at 06:10
I want execute both of select and update in SQL Instead asp.net — Farzaneh Talebi, Dec 01 '15 at 06:17

score -1 · Accepted Answer · edited May 23 '17 at 10:28

-1

Yes it is possible in SQL.

1. Create temporary table in SQL.
2. Insert data into temporary table.
3. Access temp table data using while loop.
4. update single record one by one in while loop.

Select and update in single statment : How do I UPDATE from a SELECT in SQL Server?

Using temp table : In SQL Server, how to create while loop in select

edited May 23 '17 at 10:28

Community

1
1

answered Dec 01 '15 at 06:07

Kaushik Maheta

1,741
1
18
27

Find all row and execute code for each row in sql

1 Answers1