前言: 开发小笔记~
正文:
下文函数用于创建游标过程
ALTER PROCEDURE [dbo].[testfunction]
DECLARE @test varchar(10)
BEGIN
select 1
END
select b.id.b.name = STUFF(select ','+a.name from a where a.id = b.id FOR XML path('')),1,1,'')from b group by b.id
该函数用户多行转一行;
SELECT column2,test1,test2 from (select count(*)num,column1,column2 from table)a pivot (max(num) for column1 in(test1,test2))a
该函数用户行转列;