In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs.

WHERE ProductID = 1 Cascade with care You can use cascading constraints in SQL Server to set related values to NULL, to set affected values to original default values, or to delete columns.

I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.The problem I'm running into is SQL Server exports NULL values as ...