sql multi statement table valued functions

SQL Server allows us to create our functions called as user defined functions in SQL Server.