DECLARE @p nvarchar(1000)

set @p=N'select Base_MoneyPayRec.id,UserName=(case when Base_MoneyPayRec.RecType=1 then (select OwerName from Base_House where Id=Base_MoneyPayRec.HId )else(select OwerName from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId )) end),FloorName=(case when Base_MoneyPayRec.RecType=1 then ( select FloorName from Base_Building where Id=(select BdId from Base_House where Id=Base_MoneyPayRec.HId)) else (select FloorName from  Base_Building where Id=(select BdId from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId)) ) end),UnitNmb=(case when Base_MoneyPayRec.RecType=1 then ( select UnitNmb from Base_House where Id=Base_MoneyPayRec.HId)else (select UnitNmb from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId))end),HouseNum=(case when Base_MoneyPayRec.RecType=1 then HouseNum else (select HourseNmb from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId)) end), ItemName =(Stuff((select ''、'' + ItemName from Base_MoyItem where Id in(select ItemId  from Base_MoyExpenseRec where '',''+(Case when RIGHT(Base_MoneyPayRec.LinkIds,1)='','' then LEFT (Base_MoneyPayRec.LinkIds,LEN(Base_MoneyPayRec.LinkIds)-1) else Base_MoneyPayRec.LinkIds end)+'','' like ''%,''+convert(varchar, Id)+'',%'' ) for XML Path('''')),1,1,'''')),AddTime,Money,PrefeMoney,ChargeMoney,OffsetMoney,RealMoney,UName,PayType,PayCode,ReMark from Base_MoneyPayRec'


Exec sp_executesql @p

通过以上代码在SQLsever中执行的时候，会报出错误：

然后如果直接执行SQL的话,就没问题

Exec sp_executesql N'select Base_MoneyPayRec.id,UserName=(case when Base_MoneyPayRec.RecType=1 then (select OwerName from Base_House where Id=Base_MoneyPayRec.HId )else(select OwerName from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId )) end),FloorName=(case when Base_MoneyPayRec.RecType=1 then ( select FloorName from Base_Building where Id=(select BdId from Base_House where Id=Base_MoneyPayRec.HId)) else (select FloorName from  Base_Building where Id=(select BdId from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId)) ) end),UnitNmb=(case when Base_MoneyPayRec.RecType=1 then ( select UnitNmb from Base_House where Id=Base_MoneyPayRec.HId)else (select UnitNmb from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId))end),HouseNum=(case when Base_MoneyPayRec.RecType=1 then HouseNum else (select HourseNmb from Base_House where Id=(select UserId from Base_Park where Id=Base_MoneyPayRec.HId)) end), ItemName =(Stuff((select ''、'' + ItemName from Base_MoyItem where Id in(select ItemId  from Base_MoyExpenseRec where '',''+(Case when RIGHT(Base_MoneyPayRec.LinkIds,1)='','' then LEFT (Base_MoneyPayRec.LinkIds,LEN(Base_MoneyPayRec.LinkIds)-1) else Base_MoneyPayRec.LinkIds end)+'','' like ''%,''+convert(varchar, Id)+'',%'' ) for XML Path('''')),1,1,'''')),AddTime,Money,PrefeMoney,ChargeMoney,OffsetMoney,RealMoney,UName,PayType,PayCode,ReMark from Base_MoneyPayRec where 1=1 and GetState=1 and ((HId in (select id from Base_House where  1=1 and cid = 79) and RecType=1) or (HId in (select id from Base_Park where UserId in(select id from Base_House where  1=1 and cid = 79)) and RecType=2))'

请问这是为什么呢？