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 MoreTag: Cursor
Simple cursor in SQL Server
A 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 MoreSimple cursor in SQL Server to insert records
This 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 MoreSQL Server – What Is A Cursor?
Hey 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 MoreSQL Server: A query with an ORDER BY clause cannot be used as a table expression
Hi 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