Working with Access 2010 & SQL Server 2008 has given me 2 questions ...
1) Why would Access show a non printable character that SSMS does not show?
2) How can I write a query (in T-SQL if not ANSI 92 SQL) that returns only
non zero length & printable characters? I cannot change anything to do with
SQL Server; I can only read from the tables.
I tested my pass through queries in SSMS and it all looks fine, but when I
display one of them in Access I'm seeing a non-printable character (a tab
character) in the last column of a SELECT * FROM [table] pass through (query
is for data techs to be able to diagnose bad data problems).
The tables (on MSSQL) are populated via a bulk insert procedure that
converts nulls to zero length strings. I'm supposed to be creating a related
query that shows the frequency of certain columns containing data, and I'm
told that the non printable character isn't hurting anything else and won't
be fixed any time soon.
Any help would be most appreciated.
~*~*~*~*~*~*~
Shay Bella Holmes
~*~*~*~*~*~*~
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar