|Programming in MS SQL Server 2012|
Table variable is a special data type that used to stores a query result set temporarily in memory for processing at a later time. Table variable can define in user defined functions, stored procedures and program batches. Table variable's data value automatically erases when end of the function, stored procedure or program batch.
The following user defined function describes to display Department wise Employee Phone Numbers through Table Data Type.
Query Output Screen
More Reference URL: http://technet.microsoft.com/en-us/library/ms175010.aspx
* * * * *