Default value to param

[The Clansman]

Hello,
I am calling a stored procedure and if one field is empty, I want to make
this field get its default value that is set in db, how do I do that?

thanks!

 

[Cowboy \(Gregory A. Beamer\)]

Set a default in the sproc.

CREATE PROCEDURE X
(
var1 int = 0
)
AS

INSERT INTO ...

With Oracle, you have to put a colon before the =.

Either ignore attaching this particular param (which sets to default) or
supply default in you ADO.NET to ensure everything works as expected.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

****************************. *********************
Think outside the box!
*************************************************

 

[Cor Ligthert]

Clansman,

Do you mean the SQLparameters (or OleDBparameters) know that this is almost
the only difference in code between SQLClient and OleDb.

http://msdn.microsoft.com/library/d...tasqlclientsqlcommandclassparameterstopic.asp

I hope this helps?

Cor