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.


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