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).
Copy the iTunes folder to your external drive. To copy all the items in your iTunes library (including the iTunes Library file that holds all your playlists, playcounts, ratings, and other data) to your external drive: 1  Quit iTunes.2  Locate your external drive. 3  Mac: On the desktop or Finder sidebar. 4  Windows: In My Computer.hen you need to restore your backed up iTunes Library from your external drive to your computer: 1  Quit iTunes. 2  Locate your external drive. 3  Mac: On the Desktop or Finder sidebar.