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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-12 : 11:14:43
|
| Reet writes "Hi, i am in hurry with inserting long html code into sql server text field, using stored procedure. The application that generates the html is written in c#. The strings longer than ca 900 characters are eaten up, I cannot see any error messages. Can anybody give a hint what to do about it?thanks a lot, Reet" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-12 : 11:28:22
|
| Are they being truncated on insert or when you try to view?Try looking at datalength(col) to see how long the text value is.Use substring to look at the data past 900 chars.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-07-12 : 11:28:40
|
| How do you know they are eaten up? Where are you viewing these results?Help us help YOU!Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected)EDIT: REPOST of this topic http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68936 |
|
|
|
|
|
|
insert long string into text datatype field