MSSQL and Stored Procedures

From: Carsten Lex (c.lex_at_deepweb.de)
Date: 03/03/04 

Date: Wed, 03 Mar 2004 20:50:11 +0100

Hi,

I have a Stored Procedure like this:

create function orte() returns @tab_orte TABLE{ id nvarchar, name nvarchar}
as
...
return
end

How do i receive the result via jdbc?

thanks a lot

Carsten

Relevant Pages

  • Re: Parameters
    ... ALTER FUNCTION dbo.My_Function2(@order nvarchar (10), ... In the listbox simple selection mode i used the following code: ... > generated sql and drop the stored procedure, or you can make the stored ... > It looks like your performing a query against a stored procedure. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: problems inserting into sql using SqlHelper.ExecuteScalar
    ... Here is the code and the stored procedure I'm ... > @Cont1FirstName nvarchar, ... > @Presort bit, ... > It returns the correct id number but the varchar fields are only recieving ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: STRANGE PROBLEM
    ... It is damn bad practise lah encik. ... im looping SqlCommand in a while loop. ... @MarkaLink NVARCHAR, ... You add parameters to the stored procedure in a loop.So u add the parameters while true.You should not add parameters in a loop ...
    (microsoft.public.dotnet.languages.csharp)
  • Datatype-convertion in TSQL
    ... Can I convert the data within the Stored Procedure for selecting and sorting ... The client wants to stay with the comma-format because it is common-used ... The format can be TSQL-format in the resultset of a Stored Procedure without ...
    (comp.databases.ms-sqlserver)
  • Re: Help Retrieving XML with HTTP within stored procedure ..
    ... > Within a stored procedure, I need to retrieve XML over HTTP from an ... you can make an nvarchar value. ... (Need nvarchar for OPENXML). ...
    (microsoft.public.sqlserver.programming)