Calling Stored Proc With Default Params From .NET Not Working.

All,

I have the following :

ALTER PROCEDURE [dbo].[sp_FindNameJon]



@NameName varchar(50)='',

@NameAddress varchar(50)='',

@NameCity varchar(50)='',

@NameState varchar(2)='',

@NameZip varchar(15)='',

@NamePhone varchar(25)='',

@NameTypeId int=0,

@BureauId int,

@Page int=1,

@Count int=100000

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @SqlString nvarchar(3000),@SelectClause nvarchar(1000), @FromClause nvarchar(1000),@WhereClause nvarchar(1000)

DECLARE @ParentSqlString nvarchar(4000)

DECLARE @Start int, @End int

INSERT into aaJonTemp values (@Page, 'here2', @NameCity);

 

And inside of aaJonTemp, I have the following :





NULL
here2
NULL

NULL
here2
NULL

 

How is this possible?  If @Page or @NameCity is NULL, how come it doesn't default to a value in the stored proc?

 

Thx

jonpfl