What is a #Cursor

Question

Seeder question

This is a Regular Cursor

Declare MyCursor cursor for
Select Id, Name 
From Customer

This is a #Cursor

Declare #MyCursor cursor for
Select Id, Name 
From Customer

Questions:

What is the difference?
- Is one preferred over the other?
- Is it the same difference as in a TABLE and a #TABLE?

Answer 1

0

I believe the origin of this goes back to Pandora. When she opened the box, the ills and mischief of man and all that is evil spilled out, leaving only one thing left in the box--that thing was not a cursor...

answered Mar 19 '10 at 09:10 PM

Scot Hauder
5.7k ● 13 ● 15 ● 18

Awesome answer.

Mar 20 '10 at 01:56 AM TimothyAWiseman

+1 - epic suggestion, off to update wikipedia's Pandora's Box entry ...

Mar 20 '10 at 07:41 AM Fatherjack ♦♦

(comments are locked)

Answer 2

0

I believe this just to be a naming convention and a matter of preference. If I use a cursor I use the following:

Declare @MyCursor cursor for
Select Id, Name 
From Customer

answered Mar 19 '10 at 07:13 PM

CirqueDeSQLeil
3.9k ● 6 ● 11 ● 15

(comments are locked)

What is a #Cursor

Follow this question

Related Questions