Setting Edit Stored Procedure Variable dialog box options The purpose of this dialog box is to edit stored procedure parameters. You can change values as necessary.
Procedure
The name of the variable you are editing appears in the Name field.
Select the variable type from the pop-up menu.
Enter the size of the variable.
Select a direction from the pop-up menu.
A stored procedure might have input values, output values, or both input and
output values.
Enter a test value.
Enter a value.
Click the Build button to build the value.
The Build Value dialog box appears. To complete the dialog box, see Setting
the Build Value dialog box options.
Click OK
Setting the Build Value dialog box options
The purpose of this dialog box is to build your stored procedure value.
Procedure
Select a source from the pop-up menu.
Enter a default value.
Click OK.
. 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 422