我如何...在存储过程中获取ISNULL表达式 [英] How do I...get ISNULL Expression in Stored Procedure

问题描述

我在Sql Server中要求SP

如果Agent_Hierarchy中的Agent.FirstName和Agent.LastName为Null那么'我需要选择

来自不同数据库的代理的Agent.FirstName和Agent.LastName。以下是我的代码，但我无法得到结果





任何人都可以找到解决方案..

Hi ,
I have an requirement for SP in Sql Server
If Agent.FirstName and Agent.LastName in Agent_Hierarchy is Null Then' I need to Pick
Agent.FirstName and Agent.LastName from hagent of Different Data base. The below is my Code but i am unable to get the result


Any one can find soln..

CREATE PROCEDURE [dbo].[WIN_IdleHoursAgent]          
(                          
@StartDate AS SMALLDATETIME  
         
)        
AS                 
DECLARE                           
@SQL VARCHAR(MAX)
@AgentName VARCHAR(MAX)   
SET @AgentName=ISNULL(AH.Agent_LastName,[CS_RAW_DATA].[dbo].[hagent].[Item_Name]) AND ISNULL(AH.Agent_LastName,[CS_RAW_DATA].[dbo].[hagent].[Item_Name])               
SELECT @AgentName=@AgentName
BEGIN        
 SET @SQL = '       
SELECT @AgentName As Agent_Name,      
       x.LogId As Agent_Id)x LEFT JOIN [WEDW].[dbo].[Agent_Hierarchy] AS AH
END  

推荐答案

ISNULL是一个在目标表达式为空时重新生成默认值的函数。我想你想要：

AH.Agent_LastName，[CS_RAW_DATA]。[dbo]。[hagent]。[Item_Name] IS NULL



当字段为空时，返回TRUE

ISNULL is a function that reurns a default value when the target expression is null. I think that you want:
AH.Agent_LastName,[CS_RAW_DATA].[dbo].[hagent].[Item_Name] IS NULL

This returns TRUE when the field is null

这篇关于我如何...在存储过程中获取ISNULL表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！