Database Reference
In-Depth Information
Listing 20-3. Executing Stored Procedure to Insert Currency
Exec dbo.InsertCurrency_CS 'ABC','United States of America'
Note You have to specify a unique value for the currency code. For example, I used ABC, because I know there
is no such currency for United States. But If you try to enter USD or a duplicate value, you will receive a System
error. If you add a duplicate value to the Sales.Currency table for the CurrencyCode column, you will get an
exception, as shown in Figure 20-8.
Figure 20-8. Showing argument exception in the event of a duplicate entry
 
Search WWH ::




Custom Search