This video shows writing a Scalar-Valued SQL Function that takes Parameter. The video also walks you through different parameter passing techniques