Warning: Always specify nullability!

Warning: Always specify nullability!

Post by Steve Jorgense » Mon, 20 May 1996 04:00:00

I have found at least one case where the SQL Server 6.0 documentation is
wrong, and the default nullability will not always be used.

I was calling a stored procedure from Access which worked in testing,
and worked for a while in production.  Eventually, the procedure stopped
returning results.  It would start working again for any given user when
they exited Access and restarted it.

The problem turned out to be that a temporary table created and used in
the sp has a field which must often allow null values, but I had not
specified the nullability.  Sometimes the field would allow nulls,
and sometimes not.  Access was unaware that and error had occurred in
the sp.  Of course, I will now start including error handling and
raiserror in my stored procedures so this kind of problem will be easier
to find.



A user "anonymous" has posted a massage with "Michelle" in the subject
to this

When opening this message with Netscape-Messenger it installs a new
to be retrieved and opens a internet-connection to a specific server.

I do not know at the moment, if anything else happens, or if other
will be affected too.


* Any opinions written in this e-mail are my own. They may not
correspond to  *
* those of my
company.                                                        *
* Wolfgang Zager                      Berghauser Str.
104                     *
* BAB Data-Systems GmbH               D-42349
Wuppertal                       *
* Abt. Programmierung                 Tel.  : +49 202
479870                  *
*                                     Fax   : +49 202
470035                  *
*                                     E-Mail:


2. Really BIG problem. $1000 reward if you can help with a solution

3. altering nullability constraint on a table column to setup a PK

4. SQL6.5 accessing from UNIX.

5. How change nullability of user defined type???

6. Finding Dependencies

7. T-SQL to change Nullability

8. FAQ

9. Modify column nullability in 7.0

10. Key, Index, and Nullability information through ODBC

11. Column Nullability

12. transfer completed with warnings - where are warnings?