Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Cursorless Cursor

By nagdimunovd,

Here is as sample of implementing cursor.
In some cases my tests showed that this approach performs better than native cursors in SQL Server.
All you have to do is move the dataset into a temp table with a new Identity column and then use a simple loop to extract the data as you would do normally in a cursor.
The major downside of this approach is using it with a large table.
There are couple of ways to create a temp table, you can do it with SELECT INTO, INSERT INTO, Table variable in SQL 2000.
Again each one of theese methods has it's own disadvantages based on the task, with Insert into table has to be created before the data is moved.
Bellow is an example of SELECT INTO implementation

Total article views: 1864 | Views in the last 30 days: 8
 
Related Articles
FORUM

Cursor

cursor

FORUM

cursor problem

cursors

FORUM

Cursor

Cursor Examples Wanted

FORUM

Cursor

How do cursor work?

Tags
miscellaneous    
t-sql    
 
Contribute