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 - 2004-12-06 : 08:41:11
|
| BhanuPrakash writes "I am running sqlserver 2000 on my system. In that i have created one database, in whihc i created a one tablecreate table tbl_resume(username varchar(50) not null,Resume varchar(7000) not null,experience integer not null,salary bigint not nulll)then i try to update my table with the value of resume having some 20 lines of code which consists of more than 3000 bites with around 25 lines , but unfortunately only 4 lines were added what could be the reason for the failure of updating total 25 lines." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-06 : 08:43:33
|
| What was the error and how are you trying to update?And how are you viewing the data.Try looking at len(resume)==========================================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. |
 |
|
|
|
|
|
Column length in a table