在关键字'('附近有语法错误 Incorrect syntax near '(' in sql server table values function...

from dbo.ocm_map_PositionRelation pp left join 

dbo.[fun_GetAsIsPEPropertyExtent](getdate()) ps on pp.PositionId = ps.PositionID

 

 

解决方法:

 

1. You need CROSS or OUTER APPLY
2. You need to be on SQL Server 2005+
3. And most important, the database compatibility needs to be 90 or higher

转载于:https://www.cnblogs.com/Qbit/archive/2012/07/11/2586139.html