简易生成表数据insert语句

set nocount on

select 'insert into test(id, name, description) values(''' + convert(varchar(10), id) + ''', ''' + name + ''',''' +description + ''')' + char(13) + char(10)

from test --可以加过滤条件

set nocount off