About DEBUGGING
-
How do I debug stored procedures that has an in and out tyupe of parameter? I keep getting the message.. declare the value for that parameter.
-
Hi the declaration of parameters takes place in the create statement.
CREATE PROCEDURE au_info
@lastname varchar(40),
@firstname varchar(20)
AS ......
You can then call the procedure using
EXECUTE au_info 'Dull', 'Ann'
-- Or
EXECUTE au_info @lastname = 'Dull', @firstname = 'Ann'
-- Or
EXECUTE au_info @firstname = 'Ann', @lastname = 'Dull'
-- Or
EXEC au_info 'Dull', 'Ann'
-- Or
EXEC au_info @lastname = 'Dull', @firstname = 'Ann'
-- Or
EXEC au_info @firstname = 'Ann', @lastname = 'Dull'
Check BOL for more informatnon.
HTH
Mike
-
If you want to debug the stored procedure, perform the following:
Go into query analyzer. Hit F8 to make sure you have the object browser open.
Then find the stored procedure inn the list, right click your mouse over it and select dedug.. from the bottom of the menu.
You will get a box that pops up. On the left hand side, select the paramter and enter a value on the right hand side. Do this for all the parameters. Then hit execute and away you go. Use the toolbar at the top to step through the code etc
------------------------------
The Users are always right - when I'm not wrong! -
Yup.. but I guess, the client has no permission.. anyways.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply