How can I get this to insert a NULL value if nothing is passed to @StoryCount, I am getting the following error
Microsoft OLE DB Provider for SQL Server error '80040e07'
Error converting data type varchar to int.
modify_story.asp, line 35

CREATE PROCEDURE sp_InsertStoryCount
(
@StoryCount int,
@Header varchar(60), ---line 35
@NewID int OUTPUT
)
AS
BEGIN
INSERT INTO my_Database
(StoryCount, Header)
VALUES
(@StoryCount, @Header)
SELECT @NewID = @@IDENTITY
END

Peace
Mike

Peace
Mike
http://www.eclecticpixel.com
http://www.homegrownmusicjam.com

__________________
Peace
Mike
http://www.eclecticpixel.com

You can just pass NULL. You may be putting it between quotes('NULL').

as per Madhu change the default value to NULL, one thing use SCOPE_IDENTITY() rather than @@IDENTITY (look in the books Online)

CREATE PROCEDURE sp_InsertStoryCount
(
@StoryCount int,
@Header varchar(60)= NULL,
@NewID int OUTPUT
)
AS
BEGIN
INSERT INTO my_Database
(StoryCount, Header)
VALUES
(@StoryCount, @Header)
SELECT @NewID = @@IDENTITY --SELECT @NEWID = Scope_Identity()
END