magritton
5/9/2014 - 1:28 PM

How to use a table value function. ufnGetContactInformation is the function

How to use a table value function. ufnGetContactInformation is the function

Use Table Value Function.sql
content_copyfile_download
USE AdventureWorks2008R2;
GO
SELECT ContactID, FirstName, LastName, JobTitle, ContactType
FROM dbo.ufnGetContactInformation(1209);
GO
SELECT ContactID, FirstName, LastName, JobTitle, ContactType
FROM dbo.ufnGetContactInformation(5);
GO