I know I've done this before years ago, but I can't remember the syntax ... INSERT INTO dbo.MyTable (ID, Name) SELECT 123, 'Timmy' UNION ...
stackoverflow.com