-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
SELECT * FROM T1
GO

SELECT 'INSERT INTO T1 VALUES('+CAST(F1 AS VARCHAR(10))+','+''''+REPLACE(F2,'''','''''')+''''+');' FROM T1
GO
