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).
It's not hard, but to do it right, you've got to let iTunes do the work for you. To get started, open iTunes and make sure the drive you want to move your library too is connected to your computer and ready to go. Next, go into your iTunes Preferences. On a PC, you'll find this under the edit menu.And for a Mac, it's under the iTunes menu. Click under the advanced tab, and where it says iTunes Music Folder location, change the location to a folder on your external drive.Next, make sure the copy files to Music Folder option is checked.t's not hard, but to do it right, you've got to let iTunes do the work for you. To get started, open iTunes and make sure the drive you want to move your library too is connected to your computer and ready to go. Next, go into your iTunes Preferences. On a PC, you'll find this under the edit menu.