Generated using SQL Data Dictionary demo version.


Multistatement Table Valued Function dbo.ufnGetContactInformation


Table value function returning the first name, last name, job title and contact type for a given contact.


Parameter Data Type Default
@PersonID int
Input parameter for the table value function ufnGetContactInformation. Enter a valid PersonID from the Person.Contact table.

Result:


Column Data Type Nullable
PersonID int
FirstName nvarchar(50) X
LastName nvarchar(50) X
JobTitle nvarchar(50) X
BusinessEntityType nvarchar(50) X

Uses: