spGenerateSqlStatement

IF EXISTS ( SELECT 1 FROM sys.procedures WHERE name = 'spGenerateSqlStatement' )
    DROP PROCEDURE spGenerateSqlStatement
GO
CREATE PROCEDURE spGenerateSqlStatement
    @TableName VARCHAR(256)
AS
-- TEST: spGenerateSqlStatement 'Message'
DECLARE @SqlStmt VARCHAR(MAX)
DECLARE @Fields VARCHAR(MAX)
DECLARE @Params VARCHAR(MAX)

SET @SqlStmt = 'INSERT INTO ' + @TableName + '
    ('

SET @Fields = ''
SET @Params = ''

SELECT @Fields = @Fields + ', [' + name + ']', @Params = @Params + ', @' + name
FROM sys.columns
WHERE [object_id] = OBJECT_ID(@TableName)

SET @SqlStmt = @SqlStmt + RIGHT(@Fields, LEN(@Fields) - 2) + ')
VALUES
    (' + RIGHT(@Params, LEN(@Params) - 2) + ')'

PRINT @SqlStmt
SELECT @SqlStmt