Last post May 19, 2016 09:57 AM by Das.Sandeep
May 19, 2016 09:35 AM|sudip_inn|LINK
i have seen people suggest not use cursor often. so i like to know what is bad or worse can happen when we use cursor?
why people suggest not use cursor specially in triggers.........i need the reason.
what is the pros and corns for sql server cursor?
May 19, 2016 09:55 AM|Das.Sandeep|LINK
A trigger isn't preferable to do this kind of row-by-row operation since it executes in-line with the changes to the source table, and it can affect the performance of the system negatively.
May 19, 2016 09:57 AM|Das.Sandeep|LINK
Well explained but need to enter you required details. Please refer Cursor Advantage and Disadvantage