Home » Open Source » MySQL » Print Cursor output (SQL Server)
Print Cursor output [message #633254] Fri, 13 February 2015 00:48 Go to next message
sss111ind
Messages: 579
Registered: April 2012
Location: India
Senior Member


How can we see THE output OF CURSOR IN SQL server AS we do IN Oracle.
create or replace PROCEDURE p (cur_emp out sys_refcursor)IS
BEGIN
open cur_emp for select * from emp;
end;


SET autoprint ON;
var cur refcursor;
DECLARE
begin
p(:cur);
END;

Regards,
Nathan
Re: Print Cursor output [message #633255 is a reply to message #633254] Fri, 13 February 2015 00:58 Go to previous messageGo to next message
Littlefoot
Messages: 21265
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Wouldn't you, rather, ask that question on one of MS SQL Server forums?
Re: Print Cursor output [message #633256 is a reply to message #633254] Fri, 13 February 2015 01:04 Go to previous message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why do you post a MS SQL Server question in a MySQL forum?
You know this is wrong, why do you do it?

Previous Topic: Newbie on MySQL, a few questions
Next Topic: MySQL user connection to database
Goto Forum:
  


Current Time: Wed Dec 13 23:02:07 CST 2017

Total time taken to generate the page: 0.07679 seconds