Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Quite interesting Default Value

Author  Topic 

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2001-09-26 : 15:36:36
We have sql2000 and vb 6.I set a default(=0)
and bound this default to tables
for bit and integer columns.
When we are on single tier and insert a record the default gets set to zero .

But When we are on multitier and insert a record the default value of any column does not get set to zero.we get a null value for those columns.
What's going on?
Can somebody help me out here.

   

- Advertisement -