CREATE FUNCTION fnGetClientPurchaseOrderData
(
@FromDbName varchar(50)
)
RETURNS table
AS
RETURN
(
exec( 'SELECT '[email protected]+ '.dbo.purchaseorder.*, ISNULL( '[email protected]+ '.dbo.purchaseorderContrast.ModifyDate,
'[email protected]+ '.dbo.purchaseorder.InputDate) AS ModifyDate
FROM '[email protected]+ '.dbo.purchaseorder a LEFT OUTER JOIN
'[email protected]+ '.dbo.purchaseorderContrast b ON
a.PurchaseOrderID = b.PurchaseOrderID ')
) -- 14行
这样写报错14行 ') '附近有语法错误,请问怎么改???
------解决方案--------------------
函数内是不能执行动态sql的,改造成存储过程实现吧.