File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 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
Author

SQL Procedures

Sharmilily Sha
Greenhorn

Joined: Feb 17, 2012
Posts: 11
Hi
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
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @paramSet=(SELECT paramType,paramValue FROM [DB].[dbo].[Parameter_tbl] where appId=@appId)
RETURN @paramSet
END
 
I agree. Here's the link: http://aspose.com/file-tools
 
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