What are the GLOBAL and LOCAL cursor in SQL SERVER 2005
| When we are creating a cursor by default it is Global. When is global by default we can access it from outside also. But on the other side local cursor are only accesible inside the objects these objects can be anything just like Stored Procedure,Trigger and funtion.we can also declare cusror as local or global its up to us. | |