Member Avatar for JModak

All Time Show Null value
Please help me what is the wrong in my code

declare @mxdbvlu  int
 declare @dbvlunm int
  set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1)
 if @mxdbvlu = null 
 set @dbvlunm=1000
 else 
 set @dbvlunm=sum(@mxdbvlu+1)
  select @dbvlunm,@mxdbvlu
Edited by Dani because: Moved to correct forum
  • 4 Contributors
  • 3 Replies
  • 4K Views
  • 9 Months Discussion Span
  • Latest Post Latest Post by john_111
Member Avatar for dr.vivek

Hopefully in line 4. if @mxdbvlu == null instead of if @mxdbvlu = null

Member Avatar for anand9796

I think there should be Column_name insted of Database_name
and there should be "if @mxdbvlu is null" insted of "if @mxdbvlu = null"
I tried after these changes and its working

Member Avatar for john_111

A null is never equal to something, a value can't equal null, as a null just doesn't exist. That's why you have to use the options suggested above. The second suggestion "if @mxdbvlu is null" is the standard way to test for not existing, as it says if a value doesn't exist...

Edited by john_111
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.