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?