Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to splice multiple lines of data in sql server. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1. Table structure idtypeproductCode1 pencils 00012 pencils 00023 pencils 00034 pens 00045 pens 00056 pens 00047 ballpoint pens 00078 ballpoint pens 00089 ballpoint pens. The copy code for the custom function fun is as follows: GO/* Object: UserDefinedFunction [dbo]. [fun] Script Date: 11 Yuan22Ma2011 16:09:45 * / SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate function [dbo]. [fun] (@ type nvarchar (10)) returns nvarchar (200) asbegin declare @ re nvarchar @ code nvarchar (200) set @ re='' set @ code='' select @ re=@re+productCode+' 'from T where type=@type group by productCode select @ re=left (@ re, len (@ re)-1) return @ reend

3. Query statement select type,dbo.fun (type) from (select distinct type from T) A result: pen 0004jing0005 pencils 0001pencils 0002jor0003 ballpoint pens 0007Power0008

On how to splice multiple lines of data in sql server to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.