SQL 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 …
Simple cursor in SQL server to update rows 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 …
Simple cursor in SQL Server 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 …
Simple cursor in SQL Server to insert records 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 …
SQL Server – What Is A Cursor? 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 …
SQL Server: A query with an ORDER BY clause cannot be used as a table expression Read More