I am horsing around with SQL code tonight and thought I'd try some "stuff", but this code didn't work in SQL Server 2005, but does in MySQL:

What did I do wrong? Is it the two single quotes in the word "don't"?

Here's the SELECT statement:

use AdventureWorks
insert into dbo.Album
(name, track, duration)
values
('Abbey Road', 'Don''t Let me Down', 249)