将数据库中的数据转换成insert语句的T-SQL代码如下:
if exists(select * from sys.objects where name = 'sp_generate_insert_script')
drop proc sp_generate_insert_script
go
create procedure sp_generate_insert_script
@table_list varchar(8000)='*'
as
declare @table_name nvarchar(128)
declare @column_list varchar(8000)
declare @values_list varchar(8000)
declare @sql varchar(8000)
declare @msg varchar(8000)
create table #result(sql varchar(8000))
if @table_list='*'
begin
select @table_list=@table_list+','+name from sys.objects where type='u' and name <> 'dtproperties'
set @table_list=stuff(@table_list,1,2,'')
end
while @table_list<>''
begin
if charindex(',',@table_list)>0
select @table_name=left(@ta