ISNULL Function requires 2 arguments

• nari.koud

  Ten Centuries

  Points: 1116

  More actions

  September 27, 2010 at 4:36 pm

  #228840

  Hi all,

  My querey :

  Decalre @international SMALLINT

  I am Getting @International from some other table in my cursor

  The requirement is if @international is NULL it should be 'N'

  If it is not null then it should insert @international value which i got above (from what ever joined tables)

  Then i am doing an Insert

  Insert Into Table_XYZ

  Values(1,'Abc','USA',ISNULL(@International,'N',@international) )

  Error:THE ISNULL Function requires 2 Arguments....

  Can some me helpm on this...

  Thanks

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  September 27, 2010 at 4:45 pm

  #1228084

  Yes, ISNULL does require only two arguments, you are trying to use 3 arguments.

  ISNULL ( check_expression , replacement_value )

  Andrew SQLDBA

• nari.koud

  Ten Centuries

  Points: 1116

  More actions

  September 27, 2010 at 4:47 pm

  #1228085

  it worked actually

  Values(1,'Abc','USA',ISNULL(@International,'N') )

  thanks