sql server
表值函数:
string.Format("select * from [dbo].[GetNextAuditor]('{0}',(select ApplicationTypeID from ApplicationFormList where AFNo='{0}'))", AFNo)
select * from dbo.UF_StrSplit ('sagdfeadsadsfa','a')
dbo.UF_StrSplit 为函数名
表值函数:
string.Format("select * from [dbo].[GetNextAuditor]('{0}',(select ApplicationTypeID from ApplicationFormList where AFNo='{0}'))", AFNo)
select * from dbo.UF_StrSplit ('sagdfeadsadsfa','a')
dbo.UF_StrSplit 为函数名