i have question related to the parameters in a procedure.
I am stuck at a point and the problem i am facing is that.. i have a parameter supplied through a stored procedure. But, Before the stored proc performs the its operation, taking that parameter , i need to check if that value supplied as a parameter, exists in the target table or not. If it exists i should throw and error and if does exist then i need to perform the intended action in the stored proc. how do i do it .
For example :
Problem is at the point where i have the asterisk. I am not sure how do i check the value of the parameter against the target table.
asked Aug 24 '10 at 02:41 PM in Default
I think what you would want would look roughly like
As a slightly off topic side note, I recommend explicitly listing the columns in your insert statements even where you do not technically have to. This often makes it easier for people unfamiliar with the code to read it and can provide some protection against schema changes.