example of table valued functions in sql server Example: execute table valued function in sql SELECT * FROM udfProductInYear(2017);