Positional notation specify same parameters in same order - SQL Operations

Q.  In which of the following, do you specify the same parameters in the same order as they are declared in the procedure?
- Published on 09 Jul 15

a. Positional notation
b. Named notation
c. Mixed notation
d. All mentioned above

ANSWER: Positional notation
 
Calling a stored procedure by simply just passing the parameter values and assuming that the values will be associated with the parameters in the order of the declaration is known as positional notation. In this notation the value which is passed first is associated with the first parameter, the second value with the second parameter and so on so forth. Here, the values must be passed in a proper order in a stored procedure.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)