For example, when we execute the following code, the result should be 377.97:
declare @t float
exec TotalAMount 'CA-2014-100006', @t output
print @t
Question 9:
Create a trigger InsertSubCategory which will be activated by an insert statement into the SubCategory table. The trigger will display the SubCategoryName and the CategoryName of the sub-categories which have just been inserted by the insert statement.
8 of 8
Paper No: 7
For example, when we run:
insert into SubCategory (SubCategoryName, CategoryID)
Close
+ 100%
Zoom
