File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Web Services and the fly likes SQL Procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "SQL Procedures" Watch "SQL Procedures" New topic

SQL Procedures

Sharmilily Sha

Joined: Feb 17, 2012
Posts: 11
What should be the datatype of the variable which should store multiple row results in sql stored procedures?
I want to return this variable to a C# application.

-- =============================================
CREATE PROCEDURE ParameterRetrieve
-- Add the parameters for the stored procedure here
@appId int = 0,
@paramSet nvarchar OUTPUT
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET @paramSet=(SELECT paramType,paramValue FROM [DB].[dbo].[Parameter_tbl] where appId=@appId)
RETURN @paramSet
I agree. Here's the link:
subject: SQL Procedures
Similar Threads
getting the resultset of a stored procedure?
getting ResultSet from Java Stored Procedure
SQL Server 2000 and JDBC,Registering cursor as OUT param
Stored Procedure - Can use unmapped class for result?
how to call a stored procedure which do not return a resultSet