I have a bunch of records I want to move to another database and I just want to create a bunch of inserts that I can copy and paste. I've seen someone do this before but I can't figure it out. I'm not getting the escapes right.

It's something like this where 'Code', 'Description' and 'Absent' are the columns I want from the table.

 SELECT 'INSERT INTO AttendanceCodes
          (Code, Description, Absent) 
         VALUES 
          (' + Code + ',' + Description  + ',' + Absent')'
  FROM AttendanceCodes 

The end result should be a slew of INSERTS with the correct values like this:

 INSERT INTO AttendanceCodes 
   (Code, Description, Absent) 
 VALUES 
   ('A','Unverified Absence','UA')