• --This works if ID is not identity

    declare @ID int

    set @ID = MAX(ID) + 1 FROM t_postcard

    insert into t_postCard(ID, Source, toName, toEmail, fromName, fromEmail, message, readRecept, flash, dateSent, pass) values(@ID, 'scccx', 'bxzcv', 'msdf', 'ssdf', 'sdfam', 'csdfsad', 0, 1, '01/01/2004', '2664')