Problem in UDF

Problem in UDF

 

  

Hi all,

I created an UDF with a default Param
For ex. getData(param1 integer, param2 varchar(10) = '')

but while calling the udf, select getData(10), I am getting error.
But the same is working with stored procedure.

B. Selva Balaji.
MS Sql Server LazyDBA home page