• There are so many things to describe about how to choose functions in a table. We can take example of user defined functions that return a table that can be alternative to views. It can be used where table is allowed in transact-SQL queries. User defined functions can contain additional statement and more powerful logic. It can also replace stored procedures. For example visit: http://www.codeproject.com/Articles/167399/Using-Table-Valued-Functions-in-SQL-Server