SQLServerCentral.com Content tagged cursors

Cursors for T-SQL Beginners

Fri, 27 May 2011 06:00:00 UT

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.

What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)

Wed, 01 Sep 2010 06:00:00 UT

Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.

There Must Be 15 Ways To Lose Your Cursors… Part 2

Fri, 02 Jul 2010 06:00:00 UT

Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!

There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Fri, 25 Jun 2010 06:00:00 UT

Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.

Cursors Be Gone!

Fri, 18 Jun 2010 06:00:00 UT

A short tutorial on converting cursors to more conventional loops.

There Must Be 15 Ways To Lose Your Cursors… Part 2

Fri, 02 Jul 2010 06:00:00 UT

Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!

There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Fri, 25 Jun 2010 06:00:00 UT

Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.

Avoiding cursors with SQL Server 2005

Thu, 19 Mar 2009 06:00:00 UT

Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them.

Cursors for T-SQL Beginners

Fri, 27 May 2011 06:00:00 UT

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.

Cursors Be Gone!

Fri, 18 Jun 2010 06:00:00 UT

A short tutorial on converting cursors to more conventional loops.

SQL Server Cursor Examples

Tue, 21 Oct 2008 06:00:00 UT

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?

Create Sample Data Script

Fri, 10 Oct 2008 13:58:54 UT

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.

DB Connection Killer

Tue, 09 Sep 2008 06:00:00 UT

This script opens a little cursor that will clean out connections to any DBs you specify.