[求助]如何获取表数据的insert语句

create function fmerg(@nid int )
returns varchar(500)
as
begin
declare @str varchar(500)
declare @strsql varchar(500)
declare @str1 varchar(10)
set @str1=Char(39)+','+Char(39)
set @strsql='insert into tb values('+Char(39)
set @str=''
select @str=@str+pid+@str1+id from Uni_A where id =@nid

set @strsql= @strsql+@str+Char(39)+')'

return(@strsql)
end

select id,dbo.fmerg(id) from Uni_A

insert into Uni_A values('7 ','4 ')

现在搞定了 哈哈