Deleting a Row
I have been tring to remove this one row, but cannot. I keep getting this error.
Microsoft SQL ServerManagement Studio
No Rows were deleted
A problem occurred attempting to delete Row 1.
Error Service: netSQLClient Data Provider.
Error Message string or binary date would be truncated.
The statement has been ternibated.
Correct the errors and attempt to delete the row again
or press Escape to cancel the change.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 29, 2008 9:34 PM
UPDATED:
September 29, 2008 10:20 PM
Answer Wiki:
Try using a T/SQL Command to delete the row.
<pre>DELETE TOP (1)
FROM YourTable
WHERE YourColumn = 'SomeValue'</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
