The following example uses the CASE expression in a SET statement in the table-valued function . In the AdventureWorks2012 database, all data related to people is stored in the table. For example, the person may be an employee, vendor representative, or a customer. The function returns the first and last name of a given BusinessEntityID and the contact type for that CASE expression in the SET statement determines the value to display for the column ContactType based on the existence of the BusinessEntityID column in the Employee , Vendor , or Customer tables.
Methandienone is an anabolic steroid banned from use by FDA under controlled substances act. Dianabol has been very popular in bodybuilders until its ban to increase strength and volume of their muscles. Dianabol acts strongly on androgen receptors and exerts its effects by protein synthesis and glycogen breakdown to increase muscle mass in short space of time. Dianabol produces estrogen as end product so water retention is also one of the contributors towards weight gain and increased volume. Dianabol effective dose is15-50 mg/day in men and its active life is 6-8 hours. Dianabol is excreted through kidneys and detection time in urine is 5-6 weeks. Until the ban Dianabol has been used as tonic by bodybuilders. Probably, Dianabol is effective in treatment of senile postmenopausal osteoporosis. Dianabol was also recommended in those individuals who are suffering from condition called pituitary deficient dwarfism. Dianabol was also used in those individuals who have weakened bones and always complain for exhaustion after small running and prolong walking. Still, Dianabol is prepared in large quantity in those countries where drugs regulations are weak and is used in human as well as in veterinary patients of the conditions described above.