Re: Text file inported to sql2005 table
- From: "Mecn" <mecn@xxxxxxxxx>
- Date: Thu, 10 Dec 2009 09:36:33 -0500
It's not the issue of display length.
Only when I click that row the data after / disappeared. If I move
cursor out, it shows the entire row again.
Thanks,
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9CDCF3DBCEFFEYazorman@xxxxxxxxxxxx
Mecn (mecn@xxxxxxxxx) writes:
I've bulk inserted a text file into SQL2005 table (1 big varcahr field).
I use SSMS open the table I see records --OK.
When I clicked any row, the rare part of record disappeared.
When I use sql query analyzer to select, I don't see the who field.
There are some strange chars there like /.... anythiong after it won't
show...
Run
SELECT datelength(col) FROM tbl
to display the length of the column in bytes. You can also use substring
to look at select parts.
By default SSMS does not display all text. You can control this under
Tools->Options->Query Results.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Text file inported to sql2005 table
- From: Mecn
- Re: Text file inported to sql2005 table
- From: Erland Sommarskog
- Text file inported to sql2005 table
- Prev by Date: Re: Text file inported to sql2005 table
- Next by Date: RE: Brute force attack on SQL server: Login failed for user 'sa' !
- Previous by thread: Re: Text file inported to sql2005 table
- Index(es):
Relevant Pages
|
