About cursor in sqlserver 2000
-
what are advantige and disAdvantige of using the cursor
-
what are advantige and disAdvantige of using the cursor
-
Cursors are having its own pros and cons. +Ve : Row wise operation which helps us to avoid lot of complex queries -Ve : VERY IMPORTANT, needs huge memory of SQL Server. So be careful while using cursor. It is always good if you avoid cursors as much. We have a product which has around 7500 stored procedure and we have written without any cursors :)) There are number of ways to avoid cursor.... 1) Use While Loop 2) Use Update with FROM Clause 3) Use Joins, use subqueries.. 4) Store data is views etc... 5) Last and least do good database desiging..... Amit
-
Cursors are having its own pros and cons. +Ve : Row wise operation which helps us to avoid lot of complex queries -Ve : VERY IMPORTANT, needs huge memory of SQL Server. So be careful while using cursor. It is always good if you avoid cursors as much. We have a product which has around 7500 stored procedure and we have written without any cursors :)) There are number of ways to avoid cursor.... 1) Use While Loop 2) Use Update with FROM Clause 3) Use Joins, use subqueries.. 4) Store data is views etc... 5) Last and least do good database desiging..... Amit