tqyqiutian的专栏

select stuff((select '、'+c_nmefrom alislb for xml path('')),1,1,'') as UserName,stuff((select '、'+c_pssfrom alislb for xml path('')),1,1,'') as Num,stuff((select '、' + RTRIM(c_regstt) from alislb for xml path ('')),1,1,'') as Num

--创建表CREATE TABLE [dbo].[UserInfo]( [U_id] [int] IDENTITY(1,1) NOT NULL, [UserName] [nchar](10) NULL, [PassWord] [nchar](10) NULL,CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED( [...