else @name end
end
end
fetch next from syscolumns_cursor into @name,@xtype
end
close syscolumns_cursor
deallocate syscolumns_cursor
set @sql=’set nocount on select ”insert ‘+@tablename+'(‘+@column+’) values(”as ”–”,’+@columndata+’,”)” from ‘+@tablename
print ‘–‘+@sql
exec(@sql)
if @ident is not null
print ‘SET IDENTITY_INSERT ‘+@TableName+’ OFF’
