下面將為您介紹SQL函數(shù)返回表的示例，供您參考，如果您在SQL函數(shù)返回表方面遇到了問題，不妨一看，相信對(duì)您學(xué)習(xí)SQL會(huì)有所幫助。

create function [dbo].[GetOperateCustGroup]
(
 @CustomerGuid varchar(36),
 @StrategyOperateId varchar(36)
)
returns @TempTable table (MaxPrice float,MinPrice float,[Percent] float)       
AS
begin
declare @CustomerGroupId int

select @CustomerGroupId = CustomerGroupId from T_CustGroupMember
 where CustomerGuid = @CustomerGuid
 set @CustomerGroupId=isnull(@CustomerGroupId,0)
 insert into @TempTable
 select MaxPrice,MinPrice,[Percent] from VC_T_StrategyOperateCustGroup
 where CustomerGroupId = @CustomerGroupId
 and StrategyOperateId=@StrategyOperateId

 return

end

調(diào)用方式

SELECT * FROM [GetOperateCustGroup] ('12','22')
 

【編輯推薦】

SQL中遺留的"系統(tǒng)"函數(shù)

Sql Server數(shù)據(jù)類型轉(zhuǎn)換函數(shù)

SQL漢字轉(zhuǎn)換為拼音的函數(shù)

詳解SQL中的SUBSTRING函數(shù)

SQL中的CHARINDEX函數(shù)