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).
Add items from your computer to your iTunes library. Do either of the following: 1  Drag a file or folder from the desktop to the iTunes window. 2  If you add a folder, all the files it contains are added to your library.3  If your iTunes library is empty, click the Music icon in the top-left corner, click My Music, then click Scan for Media.dd items from your computer to your iTunes library. Do either of the following: 1  Drag a file or folder from the desktop to the iTunes window. 2  If you add a folder, all the files it contains are added to your library.