Inserting Rows...
-
Dear All, In sql-server2000 In a table i am having a column of datatype varchar(8000). While inserting the record through executenonquery, i am insert only 255 characters rest of the characters are getting trucated. My question in how i will able to insert the row of that particular column more than 255 characters Thanx in advance. Regards
-
Dear All, In sql-server2000 In a table i am having a column of datatype varchar(8000). While inserting the record through executenonquery, i am insert only 255 characters rest of the characters are getting trucated. My question in how i will able to insert the row of that particular column more than 255 characters Thanx in advance. Regards
It's not the insert that gets truncated, it's the select from the table. In Query Analyser set the following option: Tools->Options->Results->Maximum Characters Per Column=8000 By the way, you can see how much data is in the column by using the datalength() function.