Why is a null value still being passed to the next insert statement in this stored procedure?

[tonyonlinux]

CREATE PROCEDURE usp_AddBook
--Variables
@Title varchar(200),
@Price decimal(18,2),
@Keywords varchar(200),
@Retired bit

AS

BEGIN
SET NOCOUNT ON

DECLARE @bookId int -- SET A VARIABLE TO HOLD THE BOOKID SQL MAKES

-- INSERT THE BOOK INFORMATION
SELECT @bookId = Book.ID from Book where Book.Title = @Title

IF @bookId = null
BEGIN
INSERT Book(Title,Price,Keywords,Retired)
VALUES
(@Title,@Price,@Keywords,@Retired)
SELECT @bookId = @@IDENTITY; -- SET THE BOOK ID TO THE ID SQL MADE
END

INSERT INTO BookNumber (BookID)
VALUES
(@bookId)
END

From my view It should check to see if the @bookID is null and if it is then do the insert if its not null then the book already exist and i simply wanna insert the bookID into the booknumber table. The sql manager keeps telling me I can't pass a null to booknumber.bookID (well yeah its non nullable column, but it shouldn't be getting a null value HELP PLEASE :) THANKS!

[Lost User]

Shouldn't that be

IF @bookId IS NULL

?

I are Troll :suss:

[tonyonlinux]

ha thanks. let me give that a go. i appreciate it!