| User defined types | SQL 2005 Adventure Works OLTP |
Properties
New data type Derived from Nullable User Flag bit No —
Referring procedures
Name Description HumanResources.uspUpdateEmployeeHireInfo Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. HumanResources.uspUpdateEmployeeLogin Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
Referring tables
Name Description HumanResources.Employee Employee information such as salary, department, and title. Person.StateProvince State and province lookup table. Production.Product Products sold or used in the manfacturing of sold products. Production.ProductProductPhoto Cross-reference table mapping products and product photos. Purchasing.Vendor Companies from whom Adventure Works Cycles purchases parts or other goods. Sales.SalesOrderHeader General sales order information.
Applies to
User defined types