Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.

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 ...