存储过程不从表中检索空值

Question

我有一个表，其中有酒店名称，但有些列有Null酒店名称。现在我只想得到那些有酒店名称的列，或者我不想从表中得到空列值。

我写的存储过程是

Alter PROCEDURE [dbo].[p_Get_HotelNamess]  
AS  
BEGIN  
   SET NOCOUNT ON;  
   SELECT
       Hotel_Info.Hotel_Name, Hotel_Info.HotelID 
   FROM 
       Hotel_Info
END

Answer 1

你应该试试这个

Alter PROCEDURE [dbo].[p_Get_HotelNamess]  
AS  
BEGIN  
 SET NOCOUNT ON;  
 SELECT 
     Hotel_Info.Hotel_Name, Hotel_Info.HotelID 
 FROM Hotel_Info 
 WHERE Hotel_Info.Hotel_Name IS NOT NULL
END