Microsoft KB Archive/110325

{|
 * width="100%"|

INF: Function dbretname Returns NULL

 * }

Q110325

-

The information in this article applies to:


 * Microsoft SQL Server Programmer's Toolkit, version 4.2

-

SUMMARY
Function dbretname will not return NULL for a stored procedure parameter name if the parameter name is not specified in a previous call to dbrpcparam or in the SQL EXEC statement.

MORE INFORMATION
For example, executing the statement,

  declare @var int exec TESTPROC @PARAM1 = @var OUT

will result in dbretname( dbproc, 1 ) returning the value "@PARAM1".

While executing the statement,

  declare @var int exec TESTPROC @var OUT

will result in dbretname( dbproc, 1 ) returning NULL.

Additional query words: dblib db_library DB-Library rpc remote stored procedure

return param

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420