–\u5efa\u7acb\u6d4b\u8bd5\u73af\u5883
\nCreate Table TEST
\n(ID Varchar(10),
\nName Nvarchar(10))
\nInsert TEST Values(’01’, N’\u5c0f\u5f20’)
\nInsert TEST Values(’01’, N’\u5c0f\u738b’)
\nInsert TEST Values(’02’, N’\u5c0f\u738b’)
\nInsert TEST Values(’02’, N’\u5c0f\u9648’)
\nGO
\n–\u5efa\u7acb\u51fd\u6570
\nCreate Function GetName(@ID Int)
\nReturns Nvarchar(2000)
\nAs
\nBegin
\nDeclare @S Nvarchar(2000)
\nSet @S=”
\nSelect @S=@S+’\uff1b’+Name from TEST Where ID=@ID Order By Name
\nReturn (Stuff(@S,1,1,”))
\nEnd
\nGO
\n–\u6d4b\u8bd5
\nSelect ID,dbo.GetName(ID) As Name from TEST Group By ID
\n–\u5220\u9664\u6d4b\u8bd5\u73af\u5883
\nDrop Table TEST
\nDrop Function GetName
\nGO
\n–\u7ed3\u679c
\n\/*
\nID Name
\n01 \u5c0f\u5f20;\u5c0f\u738b
\n02 \u5c0f\u738b;\u5c0f\u9648
\n*\/<\/p>\n","protected":false},"excerpt":{"rendered":"