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).
Part 3: Copy the iTunes backup from your old computer. To copy all of your media files, including the library file that holds all your playlists and other settings, to your new computer: 1  Locate the following folder on your new computer. 2  Windows XP: Navigate to \Documents and Settings\username\My Documents\My Music\.3  Windows Vista: Navigate to \Users\username\Music\iTunes. Drag the iTunes folder in this location onto the desktop. 2  Mac: From the Music folder to the Desktop: 3  Windows: From the My Music folder to the Desktop: 4  Locate the external drive on your new computer: 5  Mac: On the desktop.