User-defined functions that return a table data type can be powerful alternatives to views. These functions are referred to as table-valued functions. A table-valued user-defined function can be used where table or view expressions are allowed in Transact-SQL queries.
1 Go to the iTunes folder that contains the iTunes library files 2  : Windows: Navigate to \Users\ username \Music\iTunes\. 3  Drag the iTunes Library.itl file to your Desktop. 4  In the iTunes folder, open the Previous iTunes Libraries folder. Windows: Navigate to \Users\ username \Music\iTunes\. 2  Drag the iTunes Library.itl file to your Desktop. 3  In the iTunes folder, open the Previous iTunes Libraries folder. 4  Find the file named iTunes Library YYYY-MM-DD where YYYY-MM-DD is the date you updated iTunes (Year-Month-Day).
Restoring your iTunes Library. 1  Quit iTunes. 2  Locate your external hard drive. 3  On the Desktop or Finder sidebar. 4  Drag the iTunes folder (backed up earlier) from your external hard drive to whatever location you desire on your internal hard drive.5  Open iTunes while holding down the Option key (Mac) or Shift key (Windows). 6  In the resulting dialog, ...estoring your iTunes Library. 1  Quit iTunes. 2  Locate your external hard drive. 3  On the Desktop or Finder sidebar. 4  Drag the iTunes folder (backed up earlier) from your external hard drive to whatever location you desire on your internal hard drive. 5  Open iTunes while holding down the Option key (Mac) or Shift key (Windows). 6  In the resulting dialog, ...