Home Forums SQL Server 2008 SQL Server 2008 - General s there any difference in using cursor and table? RE: s there any difference in using cursor and table?
Ant-Green
SSC Guru
Points: 113445
More actions
November 8, 2012 at 5:09 am
#1557121
Yes there is typically a huge difference depending on what you want to do.
Cursors are typical RBAR meaning it processes a row at a time, where as with a table it can process a "set" of data at a time which is more effective.