CREATE function GetWifeOrg(@parent_id int)
returns @t table(col varchar(200))
as
begin
declare @sql varchar(200)
set @sql=''
if exists(select 1 from Payee_ing_Male_view A,Payee_ing_FeMale_view B where B.parent_child=A.parent_child and A.[ID]=@parent_id)
begin
select @sql=C.org_name from Payee_ing_Male_view A,Payee_ing_FeMale_view B,OrgInfo C where B.parent_child=A.parent_child and C.[ID]=B.parent_org
end
insert @t values (@sql)
return
end
我是这样写的在分析器里,不知道怎么回事!郁闷