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 a ...
At my company every foreign key has a NOT NULL constraint on it, and if it really needs to be null in some cases, a default value is assigned (like 999999) and given a row in the referring table like ...
Don’t let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. You’ve created a query that calculates an invoice total by adding the order total and the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results