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).
Steps. 1. Open iTunes and make the menu bar visible. Go into iTunes, and view your library under any of the music tabs (artists, albums, songs, it doesnât matter). On the very top left of the screen, there is a small rectangular shape that is half filled in. Click this, and a drop-down menu should appear.dd the new folder to iTunes. Click the File menu. Mac users will see the option Add to Library, while PC users will see Add Folder to Library. Click whichever of these options appears for you, and allow iTunes to open a browsing window.