CREATE FUNCTION GETLOCATIONSINFO(@locaionsId int) --- First, I named my function. I have written the value name and data type that my function will take in the brackets. RETURN SELECT *from locations ...

If you look at the way we implemented this function, it is very similar to SCALAR function, with the following differences 1. We specify TABLE as the return type, instead of any scalar data type 2.

Learn the differences between scalar and table-valued functions in T-SQL and how to use them for better query performance and readability.