Search results for: cursors

By Posted on Posted in 70-461 Training No Comments Tagged with , , , , ,

On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be a three part session on functions. This is provided free of charge to give back to the SQL community. We have been getting quite a following so …

Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs) Read more »

By Posted on Posted in 70-461 Training, TSQL No Comments Tagged with , , , , , , ,

First lets take a look at two queries using CURSORS, the first one will use the FORWARD_ONLY type cursor, and the second will use the FAST_FORWARD type cursor. These two types sound very similar, but perform quite differently. Now for the FAST_FORWARD CURSOR example. Notice only one line has changed, that’s the line that says “SET @PeoplePhoneCursor = CURSOR FAST_FORWARD …

Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD Read more »

By Posted on Posted in TSQL No Comments Tagged with , , , , , , , ,

In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a result set one row at a time. It may not be the best way to work with a set of data, but if you need to loop row by agonizing row (RBAR) in a T-SQL …

T-SQL: A Listing Databases Example Using a Cursor Read more »

By Posted on Posted in SQL 2012, SQL 2014 3 Comments Tagged with ,

I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification. After looking it over and understanding all the topics needed for the 70-461 SQL Queries certification, Aaron Buma and I we have worked out a plan to get everyone on the development team through this training. …

Free SQL Server Training Read more »

By Posted on Posted in SQL 2008, SQL 2012, SQL 2014, SQL 2016, SQL 2017, TSQL 28 Comments Tagged with , , , , , , ,

For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server that allow users to iterate through a result set one row at a time. This can be useful in situations where a user needs to perform a set of operations on each row of a …

T-SQL: A Simple Example Using a Cursor Read more »

By Posted on Posted in CTE, SQL Saturday No Comments Tagged with , , , , , , , , ,

I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but in reality can cause some very inconsistent results.   Explore alternatives to the NO_LOCK hint to get your queries to run …

Sessions submitted to SQL Saturday Vancouver BC Read more »