Skip to content
February 6, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: Cursor

SQL Server / SQL Server Accidental DBA Series

Simple cursor in SQL server to update rows

September 20, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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 More
SQL Server / SQL Server Accidental DBA Series

Simple cursor in SQL Server

September 20, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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 …

Simple cursor in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

Simple cursor in SQL Server to insert records

June 24, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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 …

Simple cursor in SQL Server to insert records Read More
SQL Server

SQL Server – What Is A Cursor?

June 27, 2011November 17, 2014 - by Piyush Bajaj - 7 Comments.

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 …

SQL Server – What Is A Cursor? Read More
SQL Server

SQL Server: A query with an ORDER BY clause cannot be used as a table expression

June 11, 2011September 30, 2014 - by Amit Bansal - 7 Comments.

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 …

SQL Server: A query with an ORDER BY clause cannot be used as a table expression Read More

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.