GenerateSqlInsertStatementFrom.sql

DECLARE @Table nvarchar(100) = 'MyTableName'

SELECT 'REPLACE(''INSERT INTO ['+@Table+'] (' +
    STUFF ((
        SELECT ', [' + name + ']'
        FROM syscolumns
        WHERE id = OBJECT_ID(@Table) AND
            name <> 'me'
        FOR XML PATH('')), 1, 1, '') +
    ') VALUES (' +
    STUFF ((
        SELECT
			'] AS nvarchar(MAX)), ''NULL'') + '''''', '''''' + ISNULL(CAST([' + name
        FROM syscolumns
        WHERE id = OBJECT_ID(@Table) AND
            name <> 'me'
        FOR XML PATH('')), 1, LEN('] AS nvarchar(MAX)), ''NULL'') + '''''', '), '') + '] AS nvarchar(MAX)), ''NULL'') + '''''')'', ''''''NULL'''''', ''NULL'')'