[dba-SQLServer] Re: Nulls in sprocs

Steven W. Erbach serbach at new.rr.com
Wed Jan 12 15:01:59 CST 2005


Robert,

Thank you very much. I shall try that.

Steve Erbach
Neenah, WI

> ------------Original Message------------
> From: "Robert L. Stewart" <rl_stewart at highstream.net>
> To: dba-sqlserver at databaseadvisors.com
> Cc: serbach at new.rr.com
> Date: Wed, Jan-12-2005 12:37 PM
> Subject: [dba-SQLServer] Re: Nulls in sprocs
> 
> Steve,
> 
> Try building the insert statement in SQL instead of using a stored 
> procedure.  When building it, you can leave out the ones that are null.
> 
> If you want to keep doing it as a stored procedure, pass null as the 
> actual 
> value.  It does not do that automatically in .Net.
> 
> Robert
> 





More information about the dba-SQLServer mailing list