04 2011 档案

摘要:1 declare @sql nvarchar(max);2 select @sql = isnull(@sql + '],[' , '') + convert(varchar, FiledId) from resumeDetail group by FiledId order by filedId;3 set @sql = '[' + @sql + ']';4 set @sql = 'select resumeId,'+ @sql +' from (select FiledText,ResumeId,Fi 阅读全文
posted @ 2011-04-29 13:46 小成时光 阅读(649) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示