by Hen » Thu, 14 Dec 2000 00:39:24
I want to debug, for example, the ISOweek function from the books online.
I have tried it with the print statement but an error occurs.
--
Computer Technology Systems B.V.
Scherpenzeel GLD, The Netherlands
http://www.cts-bv.nl
by Kalen Delane » Thu, 14 Dec 2000 04:09:25
HTH
--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
www.TheHungerSite.com
Quote:> How can i debug an user defined function (sql 2000)?
> I want to debug, for example, the ISOweek function from the books online.
> I have tried it with the print statement but an error occurs.
> --
> Computer Technology Systems B.V.
> Scherpenzeel GLD, The Netherlands
> http://www.cts-bv.nl
by Hen » Thu, 14 Dec 2000 17:01:38
Quote:>The only thing you can debug is stored procedures. But if you call the
>function from a proc, when you debug the proc, it will step through the
>function and allow you to debug it.
>HTH
>--
>Kalen Delaney
>MCSE, SQL Server MCT, MVP
>www.InsideSQLServer.com
>Feed Someone for Free Today:
> www.TheHungerSite.com
1. How to debug User Defined Function?
How to debug (i.e. make any print outs) from a UDF, that is being created?
Any selects would result in:
"Select statements included within a function cannot return data to a client."
Any prints would bring:
"Invalid use of 'PRINT' within a function."
Thank you in advance,
Alexei
3. call a user defined function from another user-defined function
5. Debugging user defined functions
6. ANNOUNCEMENT: ChangeGroup PL/SQL Server Pages 1.0 Beta 1
7. How to debug user-defined function in Sql 2K?
8. TPS for accounting apps on Intel
9. Instrinsic function in User-defined function
10. Built in function =user define function
11. scalar user-defined function require the function to be owner qualified
12. return datediff function from user defined function.
13. Mixed case function or How to create user defined function