A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a time. This can be useful for performing operations on each row of the result set individually, such as updating or deleting specific rows. Cursors are created using the DECLARE CURSOR statement, and are associated with …
In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a result set one row at a time. It may not be the best way to work with a set of data, but if you need to loop row by agonizing row (RBAR) in a T-SQL …
T-SQL: A Listing Databases Example Using a Cursor Read more »
On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors, followed by Using String Functions. This is provided free of charge to give back to the SQL community. Here is …
Using Cursors, followed by Using String Functions Read more »