Simple cursor in SQL server to update rows
The blog explains a simple cursor in SQL Server to update rows. This is just for explanation, the update query can be written without using cursor too. The T-SQL is given …
Read MoreSQL Server Education (by the geeks, for the geeks)
The blog explains a simple cursor in SQL Server to update rows. This is just for explanation, the update query can be written without using cursor too. The T-SQL is given …
Read MoreA cursor is a way to iterate each row one by one in a SQL Server table. Although, T-SQL is a set based language however, many a times need arises to …
Read MoreThis blog briefs about using a simple cursor in SQL Server to insert records. This is not a real world complex example; however it will help you to understand to use …
Read MoreHey Folks, you might be aware of the Cursor. If not then don’t worry, I will try to give some heads up: Cursors are database objects used to manipulate data in …
Read MoreHi Friends, Assume an Orders table with 2 columns (OrderID, customerID) and we try to write the following query: USE NORTHWIND GO SELECT * FROM (SELECT orderid, customerid FROM dbo.Orders ORDER …
Read More