I have a stored procedure that I am calling from another stored procedure. I like to be able to get a cursor back from the called stored procedure so I can loop through it in the calling stored procedure.
I'm not sure if you can do that directly. Even cursor variables in SQL 2000 can only be local cursors.
You could declare a global cursor in the called procedure and then use it in the calling procedure.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.