Create a user$-$defined function for the product table to fetch a particular product type based upon the user$$s preferen $--25.$ Create a user$-$defined function for the product table to fetch aparticular

$--$ product type based upon the user's preference.

Select $*$ from $[$Product$\_$Case Study$1]$

Create Function fetch$\_$function$\_$by$\_$type $($@Prod$\_$Pref Varchar$(255))$

As

Begin

$($Select $*$ from $[$Product$\_$Case Study$1]$ where Product$\_$Type $=$ Prod Pref$)$

END

Messages

Mog $156,$ Level $15,$ State $1,$ Procedure fetch$\_$function$\_$by$\_$type, Line $2[$Batch Start Line $135]$

Incorrect syntax near the keqword $\text{'}$As$\text{'}.$

Completion time: $2024-06-24T21$:$59$:$42\mathrm{.}7863990+05$:$30$ce$.$