aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
SQL Server 2000 and JDBC,Registering cursor as OUT param
getting ResultSet from Java Stored Procedure
how to call a stored procedure which do not return a resultSet
getting the resultset of a stored procedure?
Stored Procedure - Can use unmapped class for result?