How do I convert my MP3 files to the AAC format in iTunes (v7.5)?

Converting MP3 files to AAC format has many benefits but for me the main reason is much smaller files.

1. Ensure that you have added your MP3 files to the iTunes library.
2. Select the MP3 files you would like to convert then right-click on the selected files and select Convert Selection to AAC.
3. After the conversion is complete you may safely remove your MP3 files from the iTunes library.

How do I concatenate characters or strings using SQL?

Concatenation (joining 2 or more characters or strings of the same data type) is accomplished using the “+” operator. For example, let’s say that I want to join the strings “Able” and “Baker”. To do so, I would simply write:

SELECT 'Windows' + 'Vista' AS OSName

Running this query would return:
Read the rest of this entry »

How do I select only the date from a datetime data type?

Selecting only the date portion from a datetime data type could be accomplished in a number of ways. One of the most convenient methods is to simply use CONVERT and one of the many style values.

SELECT GETDATE() AS MyDate

returns the default format:
Read the rest of this entry »