1.sql2000中只能用自定义的函数解决 )) , 'aa') , 'bb') , 'aaa') , 'bbb') , 'ccc') go )) ) as begin ) select @str = isnull(@str + ',' , '') + cast(value as varchar) from tb where id = @id return @str end go --调用函数 select id , value = dbo.f_str(id) from tb group by
问题:用jmeter做接口测试时,查看结果树的数据没有显示全,给出下面的错误提示 Response too large to be displayed. Size: 1349830 > Max: 204800, 解决方法:修改jmeter.properties文件,将view.results.tree.max_size的值修改大一些,比实际的Size大. 例如:view.results.tree.max_size=2349830 然后重启jmeter,再次请求,响应结果正常显示了
有几条数据是这样的 Person 123 456 789 Person 321 654 987 想合并成 Person 444 1110 1776 直接一条linq搞定 var newQuery = from p in query group p by p.Name into g select new { Name = g.Name, Value = g.Sum(x => x.Value) };