1.创建函数 #返回表类型 create function testFunTable(@count int) returns @temptable table (intcount int ,intcountAdd int) as begin insert into @temptable values(@count,@count+1) return end 2.调用函数 SELECT * FROM dbo.testFunTable(20)