Nice article with interesting approach. I would use it in SqlServer 2000, but since SqlSever 2005 has a good XML support I would choose XML. In fact I have used...

Great article. I thing it is easy to add "exclude column" functionality:

create proc dbo.usp_generate_inserts

(

@table nvarchar(255),

@excludeCol varchar(2048)

)

as

begin

set @excludeCol = ',' + @excludeCol + ','

...

where

table_name = substring(@table, charindex('.', @table) + 1,...