Stored procedure to not to retrieve null values from table

Question

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

What are you really trying to do? have you tried just selecting count(Hotel_Name)? This will not count nulls. — Walter Mitty
– Walter Mitty, Commented Jun 7, 2013 at 12:55
I think you shouldn't have hotel names as null in the first place. It would be better to sort out it in the function where you inserting/updating the records. And then make Hotel_Name field Not null. — Indi
– Indi, Commented Jun 7, 2013 at 13:00

marc_s · Accepted Answer · 2013-06-07 13:02:09Z

3

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

edited Jun 7, 2013 at 13:02

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jun 7, 2013 at 12:49

Pawan

1,0855 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Stored procedure to not to retrieve null values from table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related