CODEWITHSUNDEEP
sql-serverstored-procedures
aami
aami

Reputation: 287

Stored procedure to not to retrieve null values from table

I have table in which I have hotel names but some columns have Null hotel names. Now I want to get only those columns having hotel names or I don't want to get null column values from table.

My stored procedure that I wrote is 

Alter PROCEDURE [dbo].[p_Get_HotelNamess]  
AS  
BEGIN  
   SET NOCOUNT ON;  

   SELECT
       Hotel_Info.Hotel_Name, Hotel_Info.HotelID 
   FROM 
       Hotel_Info

END

Upvotes: 0

Views: 1030

Answers (1)

Pawan
Pawan

Reputation: 1075

You should try this

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

Upvotes: 3

Related Questions