I am looking at a stored procedure that uses the "ISNULL" sql command. I am confused exactly what it is doing on lines 11, 12 and 13 below. Is it just assigning the input values to the column in the database table?
For example on line 11 --> One = ISNULL(inOne, One)
Is it just assigning the column One to the value inOne if the value inOne is null? I am confused about this. Can an expert please explain?
1 Create procedure inProcess
2 @inTwo VARCHAR(16)
3 @inOne VARCHAR(16)
4 @inThree VARCHAR(16)
10 FROM CUSTOMERS WHERE
11 One = ISNULL(inOne, One) AND
12 Two = ISNULL(inTwo,Two) AND
13 Three=ISNULL(inThree, Three)