一sql语句（调用自定义函数）

[txt_ly]

dbo.SF_GetPurviewByViewName( '61' , 'BU_vPo' ) 是一自定义函数，根据参数值，查出权限组合条件
drop function SF_GetPurviewByViewName
go
create function SF_GetPurviewByViewName(@empID varchar(20),@ViewName varchar(20))
returns varchar(500)
as
begin----1
declare @Purview varchar(500)
set @Purview=' and 1=1 '
return @Purview

end -----1
我现在需要在一查询语句加上权限组合条件,我的写法如下：

SELECT Count(FId) AS countNumber FROM [dbo].[BU_vPo] WHERE [BU_vPo].[FIdCUCustomer] = 1858 dbo.SF_GetPurviewByViewName( '61' , 'BU_vPo' )

求一解决方案

[yowbell]

exec('SELECT Count(FId) AS countNumber 
FROM [BU_vPo] WHERE [BU_vPo].[FIdCUCustomer] =1858 and dbo.SF_GetPurviewByViewName(''61'',''BU_vPo'')')  

[-狙击手-]

exec('SELECT Count(FId) AS countNumber FROM [dbo].[BU_vPo] WHERE [BU_vPo].[FIdCUCustomer] = 1858 '+ dbo.SF_GetPurviewByViewName( '61' , 'BU_vPo' ) )

[txt_ly]

楼上，有语法错错误
第 1 行: 'dbo' 附近有语法错误。

[txt_ly]

自己顶

[txt_ly]

楼上，有语法错错误
服务器: 消息 170，级别 15，状态 1，行 2
第 2 行: ')' 附近有语法错误。

[tengxiang05]

1.in funtion 

set   @Purview='   and   1=1   ' 
=>
set @Purview = ''' and 1 = 1 '''

2. sql

declare @sql varchar(8000)
set @slq = dbo.SF_GetPurviewByViewName(   '61'   ,   'BU_vPo'   ) 
set @sql = 'SELECT   Count(FId)   AS   countNumber   FROM   [dbo].[BU_vPo]       WHERE   [BU_vPo].[FIdCUCustomer]   =     1858 ' +  @sql

exec(@sql)