Re: Maximum number of parameters for a procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

Are you talking about a SQL Server stored procedure, or a VB method? I am
not clear.

If this is about a stored procedure, then you are limited by what SQL Server
limits you to - in which case VB 6 and VB.NET would not be a factor at all.

If this is a VB method, then I dont' see why your DBA would be a factor
here.

But in my opinion, in either case, no procedure should have 60 arguments.

"Leroy" <leroy_lemon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Ob54UMfkFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Marina.
>
> The procedure is a creation of my dba and he's a little tempermental when
> it comes to suggestions such as redesign.
> I'm in the process of converting apps to dot net from vb 6 and this one is
> on the list, but the current production copy has been modified to more
> than 60 parameters and hasn't been converted. I'm trying to determine if I
> should expidite the conversion, or do some sort of work around.
>
> Leroy
>
> "Marina" <someone@xxxxxxxxxx> wrote in message
> news:uVmx7CfkFHA.1372@xxxxxxxxxxxxxxxxxxxxxxx
>> There is no maximum as far as I know.
>>
>> However, if you are getting even close to passing 60 arguments to a
>> method, it's probably time to rethink the design of your app.
>>
>> "Leroy" <leroy_lemon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:Own3j$ekFHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hello,
>>>
>>> I have a question regarding the maximum number of parameters that can be
>>> passed to a procedure.
>>>
>>> In VB 6 the max was 60.
>>>
>>> What is the max for Dot Net?
>>>
>>> please and thanks.
>>>
>>> Leroy
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)
  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)