摘要: 一,如何将select后得出的多条记录的某个字段,拼接成字符串 CREATE TABLE TB ([UserID] INT, [LastName] VARCHAR(2), [FirstName] VARCHAR(2), [UserName] VARCHAR(2)) INSERT TB SELECT 1, 'A', 'B', 'C' UNION ALL SELECT 2, 'A1', 'B1', 'C1' UNION ALL SELECT 3, 'A2', 'B2', 阅读全文
posted @ 2012-09-02 17:43 暮山海风 阅读(148) 评论(0) 推荐(0) 编辑