Eugene Elutin (5/9/2013) Lynn Pettis (5/9/2013) Eugene Elutin (5/9/2013) Lynn Pettis (5/8/2013)
Unless you are working with Oracle, then reference cursors are the only way to return data from a stored procedure.
Sorry, what do you mean by that?
I know at least four ways of returning result(s) (data) from stored procedure in T-SQL.
Yes, T-SQL is nice in that way. I had the opportunity to work with Oracle for a year, and the methods we can use in T-SQL (MS SQL Server) don't work in Oracle. You use reference cursors to return data, which you can also use in T-SQL by returning a cursor as an outout parameter.
I'm not an Oracle expert, but I remember that it has few ways of getting back data too. Have you used pipelined functions?
Nope and where I work now I don't have to worry about writing PL/SQL either. I like T-SQL, it just seems right.
For better assistance in answering your questions, click hereFor tips to get better help with Performance Problems, click hereFor Running Totals and its variations, click here
or when working with partitioned tablesFor more about Tally Tables, click hereFor more about Cross Tabs and Pivots, click here
and hereManaging Transaction Logs
SQL Musings from the Desert Fountain Valley SQL
(My Mirror Blog)