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 |
|
ninjadude
Starting Member
2 Posts |
 Posted - 2011-02-12 : 12:30:04
|
| I hit edit top 200 rowsi edit row and then ERRORNo row updatesThe data in row 10 was not committederror source: .net sqlClient Data providerError message: String or Binary data would be truncatedCorrect errors or press esc to cancel |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-12 : 12:38:14
|
| You're trying to enter data longer than the column allows.That said, stop using the bug-ridden edit rows 'feature' and start using insert or update statements.--Gail ShawSQL Server MVP |
 |
|
|
ninjadude
Starting Member
2 Posts |
Posted - 2011-02-12 : 12:47:32
|
| where do i place the update statements iam am new to SQL, I use only MySql but this client has SQL for their database |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-12 : 18:23:18
|
| From management studio (the tool you're using), click 'new query' on the tool bar, or right-click the database in object explorer and select new query, or go to the menu, file-> new -> query.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Row was not comitted!!!