sqlserver 函数

概述CREATE function [dbo].[fn_test](@y int,@m int) returns @temp table(项目名称 varchar(100),上旬销售套数 varchar(100),中旬销售套数 varchar(100),下旬销售套数 varchar(100)) as  begin declare @dybm varchar(80)   declare @上旬销售套数 CREATE function [dbo].[fn_test](@y int,@m int) returns @temp table(项目名称 varchar(100),上旬销售套数 varchar(100),中旬销售套数 varchar(100),下旬销售套数 varchar(100)) as  begin declare @dybm varchar(80)   declare @上旬销售套数 int declare @中旬销售套数 int declare @下旬销售套数 int declare @company varchar(100) select @上旬销售套数=  COUNT(b.projguID) from dbo.s_room as a left join dbo.s_project as b on a.projguID=b.projguID where YEAR(qsdate)=@y and MONTH(qsdate)=@m and day(a.qsdate)>0 and day(a.qsdate)<=10 group by b.projguID set @上旬销售套数 =@@ROWCOUNT if(@上旬销售套数 is null) begin set @上旬销售套数=0 end select @中旬销售套数=COUNT(b.projguID) from dbo.s_room as a left join dbo.s_project as b on a.projguID=b.projguID where YEAR(qsdate)=@y and MONTH(qsdate)=@m  and day(a.qsdate)>10 and day(a.qsdate)<=20 group by b.projguID set @中旬销售套数 =@@ROWCOUNT if(@中旬销售套数 is null) begin set @中旬销售套数=0 end select @下旬销售套数= COUNT(b.projguID) from dbo.s_room as a left join dbo.s_project as b on a.projguID=b.projguID where YEAR(qsdate)=@y and MONTH(qsdate)=@m  and day(a.qsdate)>20 and day(a.qsdate)<=30 group by b.projguID set @下旬销售套数 =@@ROWCOUNT if(@下旬销售套数 is null) begin set @下旬销售套数=0 end select @company= b.company from dbo.s_room as a left join dbo.s_project as b on a.projguID=b.projguID where YEAR(qsdate)=@y and MONTH(qsdate)=@m   insert @temp values(@company,@上旬销售套数,@中旬销售套数,@下旬销售套数) return  end select * from [fn_test] (2013,4) 总结

以上是内存溢出为你收集整理的sqlserver 函数全部内容，希望文章能够帮你解决sqlserver 函数所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。