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).
1 Click Choose Library. 2  Navigate through your computer to find the external hard drive. 3  On the external hard drive, navigate to the location where you backed up your iTunes library. 4  When you find that folder (on a Mac) or a file called iTunes library.itl (on Windows), click Choose on a Mac or OK on Windows. Hold down the Option key on a Mac or the Shift key on Windows and launch iTunes. 2  Hold down that key until a window pops up asking you to Choose iTunes Library. 3  Click Choose Library. 4  Navigate through your computer to find the external hard drive.