Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2009-04-02 : 22:39:31
|
| When using the readtext it does not return the whole text but its getting truncated.. Can you please point me as to why its gettingtruncated..DECLARE @liLength int DECLARE @ptrval varbinary(16)SELECT @ptrval = TEXTPTR(Profile) , @liLength = datalength(Profile) FROM ConfigDB..BrokerEntitlements E INNER JOIN ConfigDB..BrokerProfile P ON E.BrokerProfileID = P.BrokerProfileID WHERE cNumber = 'C101197' READTEXT BrokerProfile.Profile @ptrval 0 @liLength |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-02 : 22:54:23
|
| Check your Management Studio settings, under Tools:Options:Query Results, you can increase the number of characters to display. |
 |
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2009-04-03 : 08:16:26
|
| Thanks .. But I already checked it. |
|
|
|
|
|
|
READTEXT