I\'ve executed the function already which is why now I\'m getting the red line b

Question

I've executed the function already which is why now I'm getting the red line because it already does exist. But I cannot figure out how to test it by passing things like 'mod_cook', 'business', etc. Through it.

I don't really know how to test to make sure this works. I tried a Select function but I don't think I have the syntax right to get it to work.

Create Function fn SelectFullTitleTypeS S m513 @Type Char(12)) --list of arguments, has a single argument coming in at typechar Returns NvarChar (50) -will return as AS BEGIN RETURN SELECT CASE @Type WHEN business'THEN 'Business WHEN 'mod_cook THEN 'Modern Cooking WHEN 'popular_comp' THEN 'Popular Computing' WHEN psychology' THEN Psychology WHEN 'trad_cook' THEN 'Traditional Cooking WHEN UNDECIDED' THEN 'Undecided END )this end is the end for Case END This ends the begin

Explanation / Answer

** Try this out ::

Create Function fn_SelectFullTitleTypeS_S_m513

( @Type Char(12) ) --list of arguments, has a single argument coming in at typechar

     Returns NvarChar(50) --will return as

                    AS

                      BEGIN

                                                RETURN ( SELECT CASE @Type

                                                                                                WHEN 'business' THEN 'Business'

                                                                                                WHEN 'mod_cook' THEN 'Modern Cooking'

                                                                                                WHEN 'popular_comp' THEN 'Popular Computing'

                                                                                                WHEN 'psychology' THEN 'Psychology'

                                                                                                WHEN 'trad_cook' THEN 'Traditional Cooking'

                                                                                                WHEN 'UNDECIDED' THEN 'Undecided'

                                                                                END ) --this end is the end for case

                                END; --this ends the begin       

GO

Select dbo.fn_SelectFullTitleTypeS_S_m513('mod_cook')

** You can execute function using following line

Select dbo.fn_SelectFullTitleTypeS_S_m513('mod_cook')

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.