求一段处理sql字符串的问题

[城池523]

declare @sql varchar(max)
declare @field varchar(50)
set @sql='proguid,mainguid'

想要的结果：
set @field ='a.proguid,a.mainguid'

请哪位大侠帮忙转换一下……

[ljc007]

awk 'END{split($0,a,"\x27");split(a[2],b,",");printf "set @field =\x27";for(i=1;i<length(b);i++)printf "a."b[i]",";print "a."b[i]"\x27"}' urfile

[LuoLaSiKeDe]

declare @sql varchar(max) declare @field varchar(50) declare @a varchar(50) declare @b varchar(50) set @sql='proguid,mainguid' set @a='a.'+substring(@sql,1,charindex(',',@sql)-1) set @b='a.'+substring(@sql,charindex(',',@sql)+1,len(@sql)-charindex(',',@sql)) set @field =@a+','+@b select @field