Sql转意拼接

GetWorkPosName
select b.ID,((select OrganizationName from  :EOPDBName..vw_All_Organization c where c.ID=b.OrgID)+'_'
+(case when b.GrpName is null then '' else b.GrpName+'_' end)              
+(case when b.BudName is null then '' else b.BudName+'_' end)
+(case when b.UnitNo is null or b.UnitNo='' then '' else b.UnitNo+'_' end)
+(case when b.ResCode is null then '' else b.ResCode end)) as BudCode from RCR a inner join House b on a.ResID=b.ID  where a.CstID=@CstID and b.OrgID=@OrgID


GetWorkPos
select ((select OrganizationName from  :EOPDBName..vw_All_Organization c where c.ID=b.OrgID)+'_'
+(case when b.GrpName is null then '' else b.GrpName+'_' end)              
+(case when b.BudName is null then '' else b.BudName+'_' end)
+(case when b.UnitNo is null or b.UnitNo='' then '' else b.UnitNo+'_' end)
+(case when b.ResCode is null then '' else b.ResCode end)) as BudCode from RCR a inner join House b on a.ResID=b.ID  where b.ResCode=@ResCode and b.OrgID=@OrgID