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).
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. Drag the iTunes folder to your external drive. 2  This can take a while if you have a lot of items. 3  When the transfer is complete, your iTunes Library will have been successfully copied to your external drive.