limit of SQL Parameter from dotnet

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

limit of SQL Parameter from dotnet

Author

Topic

jaggu.patil
Starting Member

3 Posts

Posted - 2009-06-08 : 08:18:34

Hi Friends,
I am calling dynamic query from dotnet.
Now the Issue is what is the limit to pass parameter to storedprocedure from apllication.

Thanks & Regards
--------------
Jagadish

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-08 : 08:21:22

Books Online has the general information about this.
If you want us to help, you have to specify which type of parameter you use (such as datatype, length and etc.).

E 12°55'05.63"
N 56°04'39.26"

jaggu.patil
Starting Member

3 Posts

Posted - 2009-06-10 : 02:05:00

This is the code
foreach (DateTime dt in objCycle.Dates)
{
foreach (string strProc in objCycle.Procedures)
{
count = count + 1;

strSPNameQuery += @"EXEC " + strProc + " @CaseId_"+count+", @CurrentDate_"+count+" , @ResultMessage_"+count+" OUTPUT;";

objSPNameParams.Add(new RPM.Data.Procedures.SQLHelper.Parameter("@CaseId_" + count, caseId));
objSPNameParams.Add(new RPM.Data.Procedures.SQLHelper.Parameter("@CurrentDate_"+count, "5/19/2009"));
objSPNameParams.Add(new RPM.Data.Procedures.SQLHelper.Parameter("@ResultMessage_"+count, "", ParameterDirection.Output));
}
}

intRecCount = objSQLHelper.ExecuteNonQuery(strSPNameQuery, CommandType.Text, objSPNameParams);
string str = objSPNameParams[2].Value.ToString();

Thanks & Regards
--------------
Jagadish

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-06-10 : 02:24:24

Hi Jagadish,

You can pass upto 256 parameter in SQL Server 2000 Stored procedure

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-10 : 02:27:52

quote:
Originally posted by senthil_nagore

Hi Jagadish,

You can pass upto 256 parameter in SQL Server 2000 Stored procedure

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

No. In SQL Server help file, refer this page
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources