Sql parameters and percentage increase : So how would one use a parameter to increase orders on the orderdetails database by 10 percent i did something like 




add parameter named “In
cPercent”) to the value of an order if the value of IncPercent is under 
10%, or if IncPercent is 10% or over, add 10% to the value of an order for all orders in the 
OrderDetails table utilising IF/ELSE.*/


code what i have so far im kinda stuck
Use SKILLAGEITDB
go
Create procedure [spAddPercentage] 
 
 @incPercent decimal(5,4)
 
 as
 update OrderDetails
 set @incPercent = @incpercent * 1.10 
***********************************************
I cannot figure out how to use the if else statement in this code. Can anyone give me a better understanding or give me a example on what i should add for if/else? 