This one has me baffled....
When I use Enterprise Manager to show (query) records from a table, Nulls are displayed as <null> and the fields are undefined. O.K. so far so good
But when I use SQL Query Analyzer to show (query) the same records from the same table, Nulls are now displayed as NULL
If I save the SQL Query Analyzer results as a delineated text file, the Null fields are now defined with the literal 'NULL' (!)
Is this a known bug, er, feature of SQL Server ?
How do I keep my Nulls as Nulls when using Query Analyzer to select and export records ?
For the record, I'm using SQL Server 2000 build 8.00.818 (SP3),
SQL Query Analyzer version 8.00.194,
All running on Windows 2000 Server, build 5.00.2195 (Service Pack 4)
When I use Enterprise Manager to show (query) records from a table, Nulls are displayed as <null> and the fields are undefined. O.K. so far so good
But when I use SQL Query Analyzer to show (query) the same records from the same table, Nulls are now displayed as NULL
If I save the SQL Query Analyzer results as a delineated text file, the Null fields are now defined with the literal 'NULL' (!)
Is this a known bug, er, feature of SQL Server ?
How do I keep my Nulls as Nulls when using Query Analyzer to select and export records ?
For the record, I'm using SQL Server 2000 build 8.00.818 (SP3),
SQL Query Analyzer version 8.00.194,
All running on Windows 2000 Server, build 5.00.2195 (Service Pack 4)