Updating record through cursor Free live chat sex forum
What you have at the moment will loop through the results rows, and if it finds a row with salary equal to 1300, if then executest he following SQL: This code is updating all the records with salary 13000.
Instead i want to update records having salary 1300 to the value 13000.
| this answer edited Jul 3 '12 at answered Jul 3 '12 at daniloquio 2,676 23 43 1 What I would add to this is, first: add an IDENTITY column to the table.
Second, make sure the data is in the correct order in respect to that column.
Variable names must be unique within a query batch or stored procedure.
There is no issue with the primary key in the d IF @First Name IS NOT NULL BEGIN SET @First Name NN = @First Name SET @Last Name NN = @Last Name SET @Emp Number NN = @Emp Number END ELSE BEGIN UPDATE Employees SET First Name = @First Name NN, Last Name = @Last Name NN, Emp Number = @Emp Number NN WHERE Effective From = @Effective From AND Effective To = @Effective To AND Job Title = @Job Title END Of course, if there are two rows with the last three columns being equal, this code will fail.
You'll get a very huge performance gain that way; or, the other way round, updates in a loop cost you a lot of performance.– Vincenzo Maggio Jul 3 '12 at Welcome to Stack Overflow: if you post code, XML or data samples, please highlight those lines in the text editor and click on the "code samples" button ( 相关推荐：c# - Inserting Multiple Records into SQL Server database using for loophe SQL Server database from an array.After entering the first row I get an exception @User ID has already been declared.Cursors allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values.Depending on the type of cursor you request, you can even fetch records that you've previously fetched.