August 3, 2006 at 2:36 am
I can't find a way to debug into user functions so i made a proc where i can debug. I can execute a function in a query but i don't know the command to call the proc from a query........
August 3, 2006 at 2:48 am
BOL would be a good place to start! Procedures are run with the execute command e.g.
exec dbo.myproc
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 3, 2006 at 11:56 am
The best way to debug function is to convert it to regular TSQL script. Comment -- create function, return, etc. Convert input parameters to variables - declare them. Run statements step by step, one at a time. Use Print keyword to return variables values.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply